Category: T-SQL


Install Adventure Works database from backup

The Adventure Works 2014 Data Warehouse database can be installed by restoring a database backup. 1. Download Adventure Works DW 2014 Full Database . 2. From File Download, click Save. Once it is saved, open the folder. 3. Extract the AdventureWorks2014.bak file to a location on your local server. Note: The default 64-bit path is C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup. Use C:\Program Files (x86)\… for 32-bit SQL Server 2014. 4. From SQL Server Management StudioRead More