Manually attach database in SQL Server

Author posted by Jitendra on Posted on under category Categories SQL Server and tagged as Tags with Leave a comment on Manually attach database in SQL Server

Download sample database of SQL server and Manually attach database in SQL Server – AdventureWorksDB

SQL server 2005, does not come with default / sample databases. so it can be downloaded and installed from http://msftdbprodsamples.codeplex.com/releases/view/4004.

After downloading, the challenge for the new developer is that how to associate database with existing SQL server installed on system.

To associate the database, follow below steps:

right click on database and select “Attach” option.

Click on Attach option of Database

one, new  popup window will appear.

Select Existing mdb file on system to attach
Select Existing mdb file on system to attach

Click on add button, then browse the file present on disc.

After selecting the file, click on OK and the file is attached.

Related posts