Recover SharePoint 2016 always on availability group cluster

Question

I have a testing sharepoint 2016 farm with a two-node SQL 2016 always on availability group cluster. After installing SQL2016 SP3 on one of the node, I found that the cluster group disappeared. I tried to revert the snapshot of the VM but cannot recover the cluster. Is there anything wrong with the upgrade of SQL2016 SP1 to SP3 that caused the cluster group to disappear? How to recover the cluster group in such a situation?

Answer 1

Hi @Terry Chan
As this problem is more related to SQL server, after I discussed it with my teammates, we would suggest you check from this official article to see whether there is some step wrong in the process of upgrade, which includes:

1. Prerequisites
2. Rolling upgrade basics for availability groups
3. Rolling upgrade process
4. AG with one remote secondary replica
5. AG with failover cluster instance nodes
6. Upgrade or update SQL Server instances with multiple AGs
7. Rolling upgrade of a distributed availability group
8. General steps to upgrade a distributed availability group
9. Diagram example for a rolling upgrade of a distributed availability group
10. Special steps for change data capture or replication
    https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-ver16

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.