Always On-manual failover - warning on possible data loss

• Hansi98

  SSC Enthusiast

  Points: 172

  More actions

  April 9, 2024 at 7:04 am

  #4409055

  Hi,

  I'm testing basic alwayson with SQL Server 2022 Standard on two servers (primary and secondary replica with an old Adventureworks database).

  The idea is to allow sql clients to continue to operate while one server is down for updating and rebooting (monthy windows and sql server updates).

  I'm testing the manual failover: Although the dashboard is showing "everything green and synchronized", the failover wizard shows a data loss warning:

  "This replica has one or more databases that are not synchronized. Failing over this replica could result in a data loss for any transaction that did not reach this secondary replicy prior to failing over".

  Why? What's wrong here or what do I miss?

  

  Also the script

  SELECT database_name, is_failover_ready FROM sys.dm_hadr_database_replica_cluster_states WHERE replica_id IN (SELECT replica_id FROM sys.dm_hadr_availability_replica_states)

  checking the failover state shows this:

  

   

   

   

   

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  April 10, 2024 at 7:10 am

  #4409559

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.