Downloading & using the AdventureWorks sample database

 

You can get the AdventureWorks database from codeplex site using the below link. I am going to use the 2008 version.

http://msftdbprodsamples.codeplex.com/releases/view/93587

after successful download you need to extract it.

image

After successful extract you will get the data and log file.

image

In the next step you need to attach it with sql server using the SQL server Management studio.Login to your SQL server using the management studio .

image 

After successful login right click on the database, this will display the context menu .

image

Click on the attach menu. It will display the attach database window.

image

Click on the add button , it will show you the locate database window.Select the database location.

image

After select , click on OK button, you will come back to previous window.You cab see that the selected database files are added to the window.

image

After this , click on the OK button and you are done 🙂 , The database will not be available to the database List.

image

Hope , you find this post useful . 🙂

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s