How to use Adventure Works 2014 Sample Databases in SQL SERVER

Follow the steps below to use  Adventure Works 2014 Sample Databases in SQL SERVER Management Studio 2012.

Step 1:

To download Adventure Works database from codeplex click here
This will download database backup zip file.

Step 2 :

Copy this backup to the location
C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup

Step 3:

Execute following script on SQL SERVER management studio


USE [master]

RESTORE DATABASE AdventureWorks2014

FROM disk= 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\AdventureWorks2014.bak'

WITH MOVE 'AdventureWorks2014_data'

TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.mdf',

MOVE 'AdventureWorks2014_Log'

TO 'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\AdventureWorks2014.ldf'

,REPLACE

Step 4 :

 

Refresh databases in object explorer to view AdventureWorks2014 database.