Post reply

Patch Principal and Mirror at The Same Time

  • January 24, 2017 at 1:09 am

    #339617

    I have synchronous mirroring between Server A and Server B and need to apply a SQL Service Pack. I have a 4 hour downtime agreed with the customer. Can I run the SP on each box at the same time?

  • January 24, 2017 at 1:58 am

    #1924538

    _nzrdb6 - Tuesday, January 24, 2017 1:09 AM

    I have synchronous mirroring between Server A and Server B and need to apply a SQL Service Pack. I have a 4 hour downtime agreed with the customer. Can I run the SP on each box at the same time?

    You can, but a better idea would be to patch the mirror first (with the principal online and serving data), then fail over to the mirror, then patch the principal, then fail back. That leaves you with no downtime other than the couple of seconds needed to fail the mirroring over each way.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 24, 2017 at 2:19 am

    #1924540

    Yes, and in the unlikely event that something goes wrong, you really don't want it going wrong on both servers!

    John

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

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