Post reply

Patching a cluster with mirrors

  • September 12, 2017 at 7:29 am

    #332565

    Here's my environment:

    Production Side:
    a 2 node cluster with 3 SQL 2012 instances
    DR Side:
    another 2 node cluster with 3 SQL 2012 instances
    The production side is mirrored to the DR side.

    I need to apply SP3 to all 3 of the instances.  How/in what order should I do this?

    Thanks!

  • September 12, 2017 at 7:36 am

    #1959092

    For mirroring, the rules are to really patch the mirror first. Stop the services on the mirror (secondary) side, apply the patches. Bring back up and sync. Then start applying patches to the primaries.

    Whether you fail over or not is up to you.

  • September 12, 2017 at 12:48 pm

    #1959170

    From cluster perspective ,I believe you can patch either way .Can start at the active node and let the patch itself propagate the upgrade to the passive or you can choose to apply it separately . You can refer the 'Read Me' on the patch for more clarity.

  • September 14, 2017 at 9:22 am

    #1959455

    So for a multi-instance cluster(s) like this I run the SP3 once and it will update all of the instances, or do I run SP3 three times, once per instance?

  • September 14, 2017 at 9:39 am

    #1959460

    You can choose to update one or more instances. The shared components for all will be updated with the first SP application.

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

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