Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019
0
votes
2
answers
63
views
Data Loss warning when trying to do failover even though Synchronized on SQL Server 2019. This is a basic availability group running in a cluster-less installation.
In the dashboard I see this:
This is the error I get:
I also checked sys.dm_hadr_database_replica_cluster_states and I see that both show is_failover_ready 1.


Asked by Russ960
(361 rep)
Jun 17, 2025, 08:50 PM
Last activity: Jun 18, 2025, 11:41 PM
Last activity: Jun 18, 2025, 11:41 PM