SQL 2012 Upgrade Steps for Mirrored Database Servers

1 min read
      Mirror was on

 

      Principal was on

 

      Witness was on

 

      Disable Backup Jobs on all servers

 

      Full Safety = 2?

 

      Remove Witness

 

      Mirrors In Sync?

 

      Suspend Mirroring

 

      Full Backup on Principal Done?

 

      RESTORE VERIFY ONLY on backup done?

 

      DBCC CHECKDB Done?

 

      SP1 & CU8 the Mirror Server & Reboot

 

      Resume the database mirroring sessions

 

      Perform manual failover

 

      Run the DBCC CHECKDB command on the “new” principal server

 

      Pause the database mirroring sessions.

 

      Install the service pack or the hotfix on the new mirror server (the old principal). & Reboot

 

      Resume the database mirroring sessions

 

      SP & CU the Witness Server & Reboot

 

      Add witness back into mirror

 

      Failback to orginal principal

 

    Re-enable backup jobs