![]() ![]() TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2014.ldf' ,Īs an alternative to steps 5 and 6, you can restore the database using the SQL Server Management Studio user interface. TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2014.mdf', USE įROM disk= 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorksDW2014.bak' You may need to update the paths in the scripts to match your environment. Execute the following code in the query window: Note: The file paths in the scripts are the default paths. On the Standard toolbar, click the New Query button. From SQL Server Management Studio connect to the 2014 instance.ĥ. Use C:\Program Files (x86)\… for 32-bit SQL Server 2014.Ĥ. Note: The default 64-bit path is C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup. Extract the AdventureWorks2014.bak file to a location on your local server. Download Adventure Works DW 2014 Full Database Backup.zip ( ). The Adventure Works 2014 Data Warehouse database can be installed by restoring a database backup.ġ. Install Adventure Works 2014 Data Warehouse database from a backup
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |