Download Sample Database AdventureWorks for SQL Server 2012
Microsoft SQL Server 2012 database administrators and T-SQL developers can download sample database AdventureWorks for SQL Server 2012, Denali CTP3.
A sample database like AdventureWorks will be very helpful to demonstrate the capabilities of SQL Server Database Engine, and other database components in action.
Especially for new enhancements, AdventureWorks database built for this task is great help for SQL Server developers and SQL Server administrators.
Download AdventureWorks Sample Database
AdventureWorks sample database for SQL Server 2012, Denali CTP3 can be downloaded from CodePlex.
Attach Database in SQL Server 2012 using SSMS
I've already download sample database AdventureWorks2008R2 for SQL11 and choose the method of database attach to set this database on my running SQL Server 2012 CTP3 instance.
Here is how you can attach sample db within a few steps and start using a mature database with data in it.
First download sample database data file.
Save the data file into SQL Server Engine Data directory where user databases exist.
Then open Microsoft SQL Server Management Studio 2011 in order to attach database AdventureWorks as SQL Server 2012 sample database.
Connect to the SQL Server 2012 Denali instance where you want to install sample database.
Right click on Databases node and from context menu choose Attach...
Then SQL Server Attach Databases tool will be displayed as shown below.
Click on Add... buton in order to select the AdventureWorks sample database data file to attach.
We are expected to point to the .mdf data file location where the target sample database files exist.
When the mdf file browser is displayed, goto file folder where AdventureWorks2008R2_Data.mdf file is in.
Then highlight the SQL Server sample database data file, and click OK.
When the sample database data file is selected, the database log file path is also fetched.
Please note the message column in the AdventureWorks2008R2 database details window:
For the log file there is a message that the log file is not found in the path displayed.
Highlight the missing log file item in the AdventureWorks database details windows.
Then click Remove buton to delete the missing log file entry from Attach Database task arguments.
Press OK buton in order to start Attach Database task in SQL Server 2012, Denali CTP3 database instance.
The processing task will attach Sample SQL Server database AdventureWorks2008R2 to SQL Server 2012, Denali.
|