SQL SERVER – Installing AdventureWorks for SQL Server

I just began with SQL Server 2012. The very first thing, I realized that there is no AdventureWorks Sample Database available for Denali. I quickly searched online and reached to Microsoft documentation where it provides information on the how to install (restore) AdventureWorks for SQL Server .

1. Download the AdventureWorks from here.
2. Run following script (replace your path of mdf file.

CREATE DATABASE AdventureWorks2008R2
ON (FILENAME = 'C:\SQL 11 CTP1\CTP1\AdventureWorks2008R2_Data.mdf')
FOR ATTACH_REBUILD_LOG ;

When you run above script it will give you following message and you are DONE!

File activation failure. The physical file name “C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2008R2_Log.ldf” may be incorrect.
New log file ‘C:\SQL 11 CTP1\CTP1\AdventureWorks2008R2_log.ldf’ was created.
Converting database ‘AdventureWorks2008R2’ from version 679 to the current version 684.
Database ‘AdventureWorks2008R2’ running the upgrade step from version 679 to version 680.
Database ‘AdventureWorks2008R2’ running the upgrade step from version 680 to version 681.
Database ‘AdventureWorks2008R2’ running the upgrade step from version 681 to version 682.
Database ‘AdventureWorks2008R2’ running the upgrade step from version 682 to version 683.
Database ‘AdventureWorks2008R2’ running the upgrade step from version 683 to version 684.

Here is the video on the same subject. The video also contains the latest AdventureWorks database.

I will soon write my experience about Denali. However, SQL Server Management Studio more started to look alike Visual Studio.

Reference: Pinal Dave (https://blog.sqlauthority.com)