Monday, 19 September 2011

Downloading & Installing AdventureWork sample database

1.                  Download AdventureWorksDB file from Microsoft link http://msftdbprodsamples.codeplex.com/releases/view/4004

2.                  run and install  the .MSI file on your system , Make sure after installing AdventureWorkDB the following files exists in folder location “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data”
a.       AdventureWorks_Data.mdf
b.      AdventureWorks_Log.ldf

3.                  Once the installation is completed then we need to attach AdventureWorksDB to SQL server.



a.       Right Click on Database,Click Attach 

b.      On Attach database screen,click Add

c.       On Locate database file, Go to folder location “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data” and select “AdventureWorks_Data.mdf” file.Click Ok.



d.      And your AdventureWorksDB added successfully.

No comments:

Post a Comment