Using Adventure Works 2008 for Sample

BY: ALBERT ANTHONY D. GAVINO

RECOMMENDED DOWNLOAD

 AdventureWorks2012_Database.zip

example, 37158K, uploaded Aug 29, 2012 - 36665 downloads

OTHER AVAILABLE DOWNLOADS

 AdventureWorksLT2012_Database.zip

example, 1131K, uploaded Aug 29, 2012 - 5988 downloads

 AdventureWorks2008R2_Database.zip

example, 36098K, uploaded Aug 29, 2012 - 48729 downloads

 AdventureWorksLT2008R2_Database.zip

example, 1028K, uploaded Aug 29, 2012 - 12976 downloads

 AdventureWorks2008_Database.zip

example, 58410K, uploaded Aug 29, 2012 - 29436 downloads

 AdventureWorksLT2008_Database.zip

example, 1353K, uploaded Aug 29, 2012 - 7854 downloads

RELEASE NOTES

About this release
This release consolidates AdventureWorks databases for SQL Server 2012,
2008R2 and 2008 versions to one page. Each zip file contains an
mdf database file and ldf log file.

This should make it easier to find and download AdventureWorks databases
since all OLTP versions are on one page.

There are no database schema changes.

For each release of the product, there is a light-weight and full version of the
AdventureWorks sample database.
The light-weight version is denoted by the LT abbreviation in the filename.

An AdventureWorks database can be installed by attaching the database, or using the
 CREATE DATABASE statement.

To attach an AdventureWorks database

1. Download a database for your SQL Server version.
2. Unzip the database (mdf) file and log (ldf) file.
3. From Microsoft SQL Server Management Studio,
   connect to a SQL Server instance.
4. Right click Databases.
5. Click Attach.
6. Click the Add button.
7. Locate the AdventureWorks database mdf file. For instance,
   AdventureWorks2012_Data.mdf.
8. Click the OK button on the Locate Database Files dialog window.
9. Click the OK button on the Attach Databases dialog window to
    attach the database.

CREATE DATABASE statement
From SQL Server Management Studio, execute the following T-SQL:

Example T-SQL

CREATE DATABASE AdventureWorks2012
 ON (FILENAME = 'M:\Data\AdventureWorks2012_Data.mdf'), 
(FILENAME = 'L:\Tlogs\AdventureWorks2012_Log.ldf') 
FOR ATTACH;