Sample Header Ad - 728x90

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: enter image description here This is the error I get: enter image description here 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