Install Samples Database AdventureWorksDW2012 for SQL Server 2012

AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.The Microsoft team keeps updating the sample database as they release new versions.

For SQL Server 2012 RTM Samples AdventureWorks Database is released:

• AdventureWorksDW2012 Data File

You can download either of the datafile and create database using the same. Here is the script which demonstrates how to create sample database in SQL Server 2012.

 

CREATE DATABASE AdventureWorks2012ON (FILENAME = 'E:\AdventureWorksDW2012_Data.mdf')FOR ATTACH_REBUILD_LOG ;

Please specify your filepath in the filename variable.

 

Note: You might get some error like "you do not have write access", in that case you need to change the properties of AdventureWorksDW2012_Data.mdf file and provide the write access to yourself and then try the steps as mentioned above.

 

Once you have executed the above statement on your SSMS, you will get this message after successful execution.

"

 

 

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorksDW2012_log.ldf" may be incorrect.

New log file 'E:\AdventureWorksDW2012_log.ldf' was created.

 

"