Msg 41104, Level 16, State 12, Line LineNumber
Failover of the availability group to the local replicafailed because the availability group resource did not come online due to aprevious error.
To identify the error, you can check the SQL Server error log, theWindows Server Failover Cluster logs and system event logs. For more informationabout how to view events and logs for a Windows Server Failover Clustering(WSFC) cluster, you can see Windows Server documentation. When you check the error log, you will find an error message that resembles the following:
The availability replica foravailability group '<AGName>' on this instance of SQL Server cannot become the primary replica. One or moredatabases are not synchronized or have not joined the availability group.
- Cumulative Update 15 for SQL Server 2017
- Cumulative Update 7 for SQL Server 2016 SP2
- Cumulative Update 15 for SQL Server 2016 SP1
Each new cumulative update for SQL Server contains all thehotfixes and all the security fixes that were included with the previouscumulative update. Check out the latest cumulative updates for SQL Server: