Forum Discussion
Tom_HJ
Dec 22, 2023Copper Contributor
SQL Server 2022: AlwaysOn AG databases can not sync after applying CU6 or higher
The setup is: OS - Win Server 2022 & MSSQL - SQL Server 2022 AlwaysOn Availability Groups are enabled on two (primary + secondary) replicas and use WSFC. Several availability groups are created an...
Tom_HJ
Copper Contributor
as an additional info, the following event appears in the sql server error logs while sql server tries to sync databases after the replica restart:
Could not process the operation. Always On Availability Groups replica manager is waiting for the host computer to start a Windows Server Failover Clustering (WSFC) cluster and join it. Either the local computer is not a cluster node, or the local cluster node is not online. If the computer is a cluster node, wait for it to join the cluster. If the computer is not a cluster node, add the computer to a WSFC cluster. Then, retry the operation.
Jan 07, 2024
Try to run the cluster validation wizard to see if the configuration for the windows cluster is OK. is quite weir to have these errors
Do you have all the nodes online in Cluster Manager ?
I doubt it is related to the SQL CU
Maybe is a good idea to open a support case for this
Regards
Javier
Do you have all the nodes online in Cluster Manager ?
I doubt it is related to the SQL CU
Maybe is a good idea to open a support case for this
Regards
Javier