Post reply

SQL 2008 R2 - Leveraging sync SQL Mirroring - rebooting principal node

  • March 23, 2011 at 4:18 pm

    #236723

    Hi

    I have SQL mirroring configured on 20+ databases.

    I need to reboot the principal server but do NOT want to failover to the mirror node.

    I just want to verify - that the reboot of the principal will not cause the mirror to failover.

    Any information you can provide is appreciated.

    Thanks.

  • March 23, 2011 at 4:30 pm

    #1302757

    If you are using a witness server it will cause a failover of the databases. You can prevent this by pausing mirroring before the reboot and then resuming mirroring after the principal is back up.

    ALTER DATABASE [DatabaseName] SET PARTNER SUSPEND

    ALTER DATABASE [DatabaseName] SET PARTNER RESUME

  • March 23, 2011 at 4:37 pm

    #1302758

    I am not using a witness server.

    I think I will pause the mirrors prior to the reboot as a precautionary measure.

    Thanks for the response.

  • March 23, 2011 at 4:42 pm

    #1302759

    Not a bad idea to pause before the reboot but it shouldn't be necessary if you are not using a witness.

    From BOL:

    http://msdn.microsoft.com/en-us/library/ms179344.aspx

    When the partners are connected and the database is already synchronized, manual failover is supported. If the mirror server instance goes down, the principal server instance is unaffected and runs exposed (that is without mirroring the data). If the principal server is lost, the mirror is suspended, but service can be forced to the mirror server (with possible data loss). For more information, see Forced Service (with Possible Data Loss).

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

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