locked
Just want to know why we need to break clustered/mirrored SQL server when installing patch. RRS feed

  • Question

  • Hi, 

    Just want to know why we need to break clustered/mirrored SQL server when installing patch. 

    Thank you so much for those who will enlighten me on this.. 

    Thanks,

    Tuesday, November 6, 2018 9:29 AM

All replies

  • Don't understand what you mean, you don't have to "break" anything to install SQL Server or Windows patches.

    See https://support.microsoft.com/en-us/help/958734/sql-server-failover-cluster-rolling-patch-and-service-pack-process


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Mohsin_A_Khan Tuesday, November 6, 2018 2:48 PM
    Tuesday, November 6, 2018 9:48 AM
  • There's no need to break anything to install a patch. Do you, instead, mean "Suspending" the Mirroring session?

    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Tuesday, November 6, 2018 2:17 PM
  • Hi Kulig101,

    There is no need to break the clustered/mirrored SQL server when installing the patch, the upgrade process will handle it. 

    Actually, for both clustered and mirrored SQL server, we will always upgrade the non-active node, then failover, after that upgrade another node. For mirrored SQL Server, if you have a witness configured, turned it OFF as during the patching. 

    Sometimes, if the upgrade duration is long, we can PAUSE mirroring to avoid huge log, but there is no need to break them. 

    Best Regards,

    Teige


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Thursday, November 8, 2018 8:36 AM
    Wednesday, November 7, 2018 6:48 AM