Installing Adventureworks database

Installing AdventureWorks

My next article onward, we are going to start writing queries. So you should have some data to work on and which should be in sync with my data.

One of the possibility for you guys to get in sync with me is to install AdventureWorks database. This is a sample database which can be used for testing & practicing purpose. Let’s install AdventureWorks in your SQL Server.

Follow the below steps to get it installed in your computer.

Step 1: Download AdventureWorks database. To download, Click here

Note: while downloading select the appropriate version according to your SQL Server version. Suppose if you are using SQL Server 2008, then download AdventureWorks 2008.

Step 2: Extract the ZIP file which you have downloaded from the above link. You will get two files (1 .mdf & 1 .ldf).

Adventureworks database

Step 3: Copy these two files to C:\Program Files\microsoft sql server\mssql11.SQLEXPRESS\mssql\DATA\ location.

Step 4: Now connect to SQL Server — Right click on Databases folder in object explorer — Click on attach — Click on Add — Select the mdf file from your AdventureWorks location — click on Ok — click on Ok.

Adventureworks database

Step 5: Now right click on databases folder — click on refresh and then check for AdventureWorks database in it.

 Ufff……… Finally we are on the same page. Now let’s start the game :)


Latest Comments
  1. manfaat cell food

    I am regular visitor, how are you everybody? This post posted at this website is actually good.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.