SP 2016 patching with SQL 2016 Always on

Tanmoy Das 796 Reputation points
2020-08-24T06:46:25.717+00:00

Hi Guys,

I have an SP 2016 farm with 2 web servers, 2 app and 2 search servers and 2 SQL nodes with Always on.

How to apply the patch in the farm?

When dbs are in sync status it can break the psconfig, is not it?

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,356 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Jon Alfred Smith 531 Reputation points
    2020-08-24T06:53:32.717+00:00

    On the SQL Server side it won't break anything. The basic steps are:

    1. Patch your Secondary/Replica first.
    2. Do fail-over and make your secondary as Primary.
    3. Patch the previous primary (currently secondary)
    4. Do fail-back and make your current secondary as Primary again.

    SQL SERVER – How to Apply Patch in AlwaysOn Availability Group Configuration?
    https://blog.sqlauthority.com/2017/03/04/sql-server-apply-patch-alwayson-availability-group-configuration/


  2. Tanmoy Das 796 Reputation points
    2020-08-24T13:15:53.63+00:00

    I am talking about SharePoint patching, not SQL.

    We have only 1 SP farm.

    Did you mean patch secondary mean, the 2nd node of SQL?

    No comments

  3. Trevor Seward 11,491 Reputation points Microsoft MVP
    2020-08-24T15:18:06.447+00:00

    When attempting for high availability, this is in general what you'd do -- note that order of patching doesn't matter, but we'll be keeping the service highly available.

    For your app and search servers, patch one node member type at a time. This way one of the node member types is always online. For your FEs, do the same but you'll want to remove the downed note from the load balancer, and bring it back online when the patching is completed. After you have all nodes patched, you need to run the config wizard. Likewise, patch only one of each type at a time and for the FEs, remove it from the load balancer.

    https://learn.microsoft.com/en-us/sharepoint/upgrade-and-update/sharepoint-server-2016-zero-downtime-patching-steps

    No comments

  4. Tanmoy Das 796 Reputation points
    2020-08-24T22:01:24.4+00:00

    Thanks, Trevor

    I was thinking more from AG point of view.
    Can it break the PS config if the dbs are in sync status.
    I have faced this issue in SP2013 with mirroring.

    No comments