Simple way to attach multiple Databases in single click

To attach multiple databases in SQL Server we can use a tweak as below

Step 1 Open Management studio and right click on Databases then select ATTACH

Step 2:- from the window click on ADD button

Step 3:- Now from the below Window select MDF file for which you want to attach database


Repeat the Step3 for all MDF files


Click on OK and all the databases will get attached J



Prashant Deshpande


Leave a comment

Filed under Uncategorized

Leave a Reply

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

You are commenting using your 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