Download and Install AdventureWorks Database

AdventureWorks Database is the sample database available online. You can use this database to practice each and every functionality that we specified in this SQL Server Tutorial. In this article we will show you step by step approach to Download and install AdventureWorks Database with screenshots.

Before we start installing AdventureWorks Database, let me show you the list of databases that are available in SQL Server.

Download and Install AdventureWorks Database

In order to download the AdventureWorks Database, please go to Downloads page, and select Adventure Works 2014 Full Database Backup.zip. If you want the data warehouses then select the Adventure Works DW 2014 Full Database Backup.zip

Click the Save button

Once the download is completed, please unzip the file. Below screenshot will show you the Unzipped file.

To install Adventure Works Database, Go to the Object Explorer. Right-click on the Databases and select the Restore Database.. option from the context menu.

Once you select the Restore Database.. option, a new window called Restore Database will be opened as we shown below.

Please select the Source as device, and click …. (Browse) button

Clicking the Browse button will open a Select backup devices window. please click on the Add button to add the adventure works backup file.

From the below screenshot you can see, we are selecting the AdventureWorks.bak file present in the file system.

Click Ok to close the window

Click OK to restore the Adventure Works database.

If everything goes well then following message will be displayed.

Please refresh the Object explorer to see our newly installed AdventureWorks database.

You can see the View, Stored procedures, Tables in this Adventure works. Please explore each and every folder to understand the data.

Thank You for Visiting Our Blog