-->

The original AdventureWorks family continues to ship for SQL Server 2008, so you have a choice of staying with the compatible schema or trying out the new SQL Server 2008 features depending on which installers you download. The installers for the AdventureWorks 2008 family all have 2008 in their names. See the link above for additional details. Install Adventure Works Database: In this article we will show you step by step approach to Download and install AdventureWorks Database with screenshots. 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. AdventureWorks sample databases are used in code examples in SQL Server Books Online and in companion samples that you can install in Microsoft SQL Server 2008. New versions of the AdventureWorks sample databases for SQL Server 2008 are now available.

I have downloaded 2008 R2 Adventure family databases EXCEPT Adventureworks2008R2 database, I can see Adventureworks, AdventureworksDW, AdventureworksDW2008R2 databases on object Explorer BUT DIDN'T see Adventureworks2008R2 database, have tried many times but failed. Is anyone can hope me to download Adventureworks2008R2 database?

APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

AdventureWorks download links and installation instructions.

Prerequisites

  • SQL Server or Azure SQL Database. For the Full version of the sample, use SQL Server Evaluation/Developer/Enterprise Edition.
  • SQL Server Management Studio. For the best results use the June 2016 release or later.

Github links

OLTP downloads

Direct links to the OLTP versions of AdventureWorks can be found below:

Itube free download windows

2008

Data Warehouse downloads

Direct links to the Data Warehouse versions of AdventureWorks can be found below:

Creation scripts

The below scripts can be used to create the entire AdventureWorks database, irrespective of version.

Adventureworks 2008 Database Download

Install to SQL Server

Restore backup

Follow the below steps to restore a backup of your database using SQL Server Management Studio.

  1. Open SQL Server Management Studio and connect to the target SQL Server instance.
  2. Right-click on the Databases node, and select Restore Database.
  3. Select Device and click the ellipses (..)
  4. In the dialog Select backup devices, click Add, navigate to the database backup in the filesystem of the server, and select the backup. Click OK.
  5. If needed, change the target location for the data and log files, in the Files pane. Note that it is best practice to place data and log files on different drives.
  6. Click OK. This will initiate the database restore. After it completes, you will have the AdventureWorks database installed on your SQL Server instance.

For more information on restoring a SQL Server database, see Restore a database backup using SSMS.

Attach a datafile

Download Adventureworks Database 2016

Follow the below steps to attach the datafile for your database using SQL Server Management Studio.

  1. Open SQL Server Management Studio and connect to the target SQL Server instance.
  2. Right-click on the Databases node, and select Attach.
  3. Select Add and navigate to the .MDF file you want to attach.
  4. Select the file and click OK.
    1. The database you selected should be displayed in the bottom window. If the file is listed as 'not found', select the ellipses (..) next to the file name and update the path to the correct path.
    2. If you only have the data file (.mdf), and not the log file (.ldf), then highlight the .ldf in the bottom window and select Remove. This will create a new log file.
  5. Select OK to attach the file. After the file is attached, you will have the AdventureWorks database installed on your SQL Server instance.

For more information on attaching database files, see Attach a database.

Adventureworks 2008 Oltp Database Download

Install to Azure SQL Database

Adventureworks Database 2008 Free Download

If you do not yet have a SQL Server in Azure, navigate to the Azure portal and create a new SQL Database. In the process of create a database, you will create a server. Make note of the server. See this tutorial to create a database in minutes.

  1. Connect to your Azure portal.
  2. Select Create a resource in the top left of the navigation pane.
  3. Select Databases and then select SQL Database.
  4. Fill in the requested information.
  5. In the Select Source field, select Sample (AdventureWorksLT) to restore a backup of the latest AdventureWorksLT backup.
  6. Select Create to create your new SQL Database, which is the restored copy of the AdventureWorksLT database.

See also

Adventureworks.mdf Database Download 2008

Tutorials for SQL Server Management Studio
Tutorials for SQL Server database engine