Attach adventureworks database to sql server 2012

broken image

# Click the OK button on the Locate Database Files dialog window.

broken image

For instance, AdventureWorks2012_Data.mdf. # Locate the AdventureWorks database mdf file. # From Microsoft SQL Server Management Studio, connect to a SQL Server instance.

broken image

# Unzip the database (mdf) file and log (ldf) file. # Download a database for your SQL Server version. The light-weight version is denoted by the LT abbreviation in the filename.Īn AdventureWorks database can be installed by attaching the database, or using the CREATE DATABASE statement. There are no database schema changes.įor each release of the product, there is a light-weight and full version of the AdventureWorks sample database. This should make it easier to find and download AdventureWorks databases since all OLTP versions are on one page. Each zip file contains an mdf database file and ldf log file. This release consolidates AdventureWorks databases for SQL Server 2012, 2008R versions to one page. *Release notes for downloads on this page:* Downloads on this page are archived on Codeplex for your convenience only.

broken image

Please update existing links to point to the GitHub release location. !! AdventureWorks downloads are available in the on GitHub.

broken image