Attach Database

  • 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.

  • 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

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply