Forum Discussion
How to perform Windows Update for SharePoint 2019 DB Cluster
Hello,
We have SharePoint 2019 with two database server in HA.
So, i need to update both Windows Server 2019 where DB services hosted, on separated days for each server.
I'm wondering if installing patches on separated days may impact SharePoint services, also i need to know the steps to follow before restart each server after installing the patch.
1 Reply
- lyradavenCopper Contributor
Thatβs a good question and one that comes up often with SharePoint farms running on clustered SQL backends. Updating the Windows Servers that host your SharePoint 2019 databases requires some care, but as long as your HA (Always On / failover cluster) is configured correctly, patching one node at a time is the recommended approach.
A few key points to keep in mind:
β One node at a time β Patch the passive node first, failover if needed, then move to the other node on a separate maintenance window. This avoids downtime.
π Failover testing β Before patching, make sure failover between nodes works cleanly. This will minimize any risk during updates.
ποΈ Backups β Always take a full SQL and SharePoint farm backup before applying patches.
π¦ Restart timing β You can restart after patching each server individually; SharePoint services will remain available as long as the cluster maintains quorum.
π Maintenance mode β Put the node under maintenance mode in Failover Cluster Manager (or suspend availability replica if using Always On AGs) before patching.
As long as you follow the proper sequence, SharePoint should continue to run without noticeable service impact while you patch the servers on separate days.