New download: We added an AdventureWorks Database zip file that contains an MDF and LDF.

Derrick's Twitter Link:

Download AdventureWorks Databases – 2008, 2008R2 and 2012

AdventureWorks OLTP database for SQL Server 2012 AdventureWorks DW database for SQL Server 2012 Azure SQL Database Get more information
AdventureWorks OLTP database for SQL Server 2008 R2 AdventureWorks DW database for SQL Server 2008 R2 Feedback Questions

AdventureWorksLT Databases: AdventureWorksLT 2012 | AdventureWorksLT 2008R2.


  • The AdventureWorks OLTP database supports standard online transaction processing scenarios for a fictitious bicycle manufacturer (Adventure Works Cycles). Scenarios include Manufacturing, Sales, Purchasing, Product Management, Contact Management, and Human Resources.
  • The AdventureWorks DW database demonstrates how to build a data warehouse.
  • The AdventureWorks LT database is a simplified and smaller sample database helpful for those new to relational database technology.
  • The SQL Azure OLTP database is a SQL Azure version of the AdventureWorks2012 database.

How To

Last edited Aug 30, 2013 at 3:12 PM by DerrickVMSFT, version 81