Manually attach database in SQL Server

SQL server 2005, does not come with default / sample databases. so it can be downloaded and installed from

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.

Leave a comment

Your email address will not be published.

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