Patching issue in SharePoint with SQL Basic always on environment

Question

We have SharePoint 2019 in MS SQL server Basic Always On cluster.

we are facing issues like when we need to be patching in SharePoint server.

needs to remove secondary SQL node from SQL basic always on cluster and re-add after patching.

Is there any idea?

Thank You

Nur Hossain

Answer 1

Hi @Nur Hossain,

Yes, there is a way to minimize downtime during patching in SharePoint 2019 with SQL Server Basic Always On cluster.

One approach is to use an approach called "rolling upgrade" or "rolling patching." In this approach, you patch one server at a time, starting with the secondary node, which can be removed from the SQL Server Basic Always On cluster, patched, and then added back to the cluster. Once the secondary node is patched and added back to the cluster, you can failover the cluster to make the secondary node the primary node, and then repeat the process for the previous primary node.

Please refer to MS document:

https://learn.microsoft.com/en-us/windows-server/failover-clustering/cluster-operating-system-rolling-upgrade

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".