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

 

Thanks

Prashant Deshpande

Advertisements

Leave a comment

Filed under Uncategorized

Leave a Reply

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

WordPress.com Logo

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