Monday, March 19, 2012

Adventure Works database for SQL Server 2012

At last during the weekend I was able to download and install SQL Server 2012 standard edition in my laptop. Next to get started I was looking for sample database for SQL Server 2012. Using the search string "adventureworks 2012 download" I found the below download link.

  • Adventure Works DB for SQL Server 2012 - http://msftdbprodsamples.codeplex.com/releases/view/55330
  • Actually it downloads the DATA file named AdventureWorks2012_Data.mdf and the size when I downloaded was 189 MB.
  • Copy the DATA file to the location where you want it to be stored in your hard drive and then make use of that path in "FILENAME" attribute within CREATE DATABASE syntax.

CREATE DATABASE AdventureWorks2012
ON
(
FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11\MSSQL\DATA\AdventureWorks2012_Data.mdf'
)
FOR ATTACH_REBUILD_LOG;



Reference: CREATE DATABASE syntax for SQL Server 2012

No comments: