SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On



Attach Database Expand / Collapse
Author
Message
Posted Friday, November 20, 2009 8:06 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 1:10 PM
Points: 444, Visits: 1,240
I did dettach around 300 databases and now i have to attach them to a drive location
D:\SQLDATA
D:\SQLLOG

Is there a script which queries windows folder to get list of all mdf files and attach them at once instead of manually attaching them.
Post #822815
Posted Friday, November 20, 2009 8:58 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:03 AM
Points: 1,427, Visits: 1,506
Tara-1044200 (11/20/2009)
I did dettach around 300 databases and now i have to attach them to a drive location
D:\SQLDATA
D:\SQLLOG

Is there a script which queries windows folder to get list of all mdf files and attach them at once instead of manually attaching them.

You have posted the same thread in the same forum 7 days back.

http://www.sqlservercentral.com/Forums/Topic818652-146-1.aspx#bm818660

Please do not reply to this post instead reply to the original thread (find the original topic included above)



Bru Medishetty

To get quick answers read the article
How to post data/code on a forum to get the best help


My Blog - learnsqlwithbru.com
Post #822822
« Prev Topic | Next Topic »


Permissions Expand / Collapse