Post reply

Copy instance to another instance

  • March 5, 2009 at 6:52 am

    #129547

    Hello everybody,

    I need some advice on copying/moving the databases (over 200) from one instance to another.

    The new instance will be on a different drive. I know how to do this manually but...it would take forever. Anybody have any good ideas on an efficient way to do this...I will be doing this multiple times over the next few weeks.

    Thanks

    Rick

  • March 5, 2009 at 2:43 pm

    #954451

    Attached is a .bat file and sql script for moving system databases. Try altering it to include the user databases.

    MJ

  • March 10, 2009 at 11:58 am

    #956987

    Thanks for the response Manu.

    Between what you provided and another script I found I can make this happen a whole lot easier.

    For anyone trying to move a ton of databases to another drive or server this detach and attach script will come in handy.

    Total credit to this guy. I tested out the script and it works flawlessly.

    Here is the URL

    http://solihinho.wordpress.com/2008/12/08/moving-database-file-to-another-disk/

  • March 10, 2009 at 12:55 pm

    #957019

    Thanks a lot for sharing the link.

    MJ

Viewing 4 posts - 1 through 3 (of 3 total)

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