Server Duplication Script???

  • Is there any script that someone has that will generate all the informtion for a particular server.  I have to create two identical servers and was thinking it would be easier to generate a script for the (db's,indexes,sp's,etc) but over 50 of them to run in QA on the new server, they are not on the same network so not able to connect and "copy/move" the databases.  Dont want to script off each one ...one at a time but i may have too. Any ideas are much appreciated.  Thanks

    DHeath

  • See "moving databases" in BOL.  This is a good article: http://support.microsoft.com/kb/314546/en-us  I'm sure I've seen stuff in the Script section of this site that will script out everything in an instance.  Try the Search on the home page. 

    Greg

    Greg

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

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