AdventureWorks2008R2

This release contains the full database backups, scripts, and projects for AdventureWorks2008R2. They are for use with SQL Server 2008R2 and later versions. This release does not include filestream. These samples are migrated from Codeplex.

For additional guidance, please review the instructions for attaching a database and restoring a database.

For multidimensional and tabular models, see AdventureWorks for Analysis services.

Feedback on this release: send to sqlserversamples@microsoft.com.

AdventureWorks2008R2 (OLTP) downloads

adventure-works-2008r2-oltp.mdf
A full database backup (.bak) file of AdventureWorks2008R2.

adventure-works-2008r2-oltp-data-file.mdf
A full database mdf file of AdventureWorks2008R2.

adventure-works-2008r2-oltp-script.zip
Script and source data files to build and install AdventureWorks2008R2.

AdventureWorksLT2008R2 and AdventureWorksLT2008 (Lightweight) downloads

adventure-works-2008r2-lt.bak
A full database backup of AdventureWorksLT2008R2.

adventure-works-2008r2-oltp-script.zip
Script and source data files to build and install AdventureWorksLT2008R2.

adventure-works-2008-lt-data-file.mdf
A full database mdf file of AdventureWorks2008R2.

AdventureWorksDW2008R2 (data warehouse) downloads

adventure-works-2008r2-dw-data-file.bak
A full database backup of AdventureWorksDW2008R2. It is a sample database for data warehousing, and provides source data for the multi-dimensional and tabular analysis projects mentioned in this release.

adventure-works-2008r2-dw-data-file.mdf
A full database mdf file of AdventureWorksDW2008R2. It is a sample database for data warehousing, and provides source data for the multi-dimensional and tabular analysis projects mentioned in this release.

adventure-works-2008r2-dw-script.zip
Script and source data files to build and install AdventureWorksDW2008R2.