Manually attach database in SQL Server

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.

Posted

in

by

Tags:


Related Posts

Comments

Leave a Reply

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

Discover more from Jitendra Zaa

Subscribe now to keep reading and get access to the full archive.

Continue Reading