Results 1 to 2 of 2

Thread: Cutover process to new server

  1. #1
    Join Date
    Nov 2002
    Posts
    261

    Cutover process to new server

    I have a new server attached to a SAN that is running log shipping that will be replaced. I have the following list to complete this an wonder if I am wrong or missing anything

    1. Stop log shipping on primary
    2. let last restores complete on failover server
    3. Backup master and msdb on primary
    4. Detach databases
    5. Replace primary with new server and attach to SAN (server will have same name and IP as former server)
    6.Bring up new sql server
    7.restore master and msdb
    8.restart log shipping

    My question is mainly on if I do a restore of the master and msdb, do I need to reatach the databases first?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Yes. Backup master database after detaching the databases, so that you can attach them after the restore.

Posting Permissions

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