Results 1 to 2 of 2

Thread: Moving the MASTER Database

  1. #1
    Cameron Guest

    Moving the MASTER Database


    We're changing our server. Both servers are SQL 2000. If I backup the MASTER on the first box and restore it on the second box (considering all the databases and... are alike) what could go wrong? Any other suggestion?

  2. #2
    S Guest

    Moving the MASTER Database (reply)

    why do a backup and restore, if they are both SQL 2000, why not just create a link between the two and copy the databases with the import/export wizard?


    ------------
    Cameron at 3/27/01 1:47:51 PM


    We're changing our server. Both servers are SQL 2000. If I backup the MASTER on the first box and restore it on the second box (considering all the databases and... are alike) what could go wrong? Any other suggestion?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •