Data synchronization state of some availability database is not healthy

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  December 1, 2016 at 7:49 pm

  #316385

  Hi,

  Getting the below warning while checking the AlwaysOn Dashboard -

  At least one availability database on this availability replica has an unhealthy data synchronization state. If this is an asynchronous-commit availability replica, all availability databases should be in the SYNCHRONIZING state. If this is a synchronous-commit availability replica, all availability databases should be in the SYNCHRONIZED state.

  This node is a set to manual Failover mode.

  Any suggestion how to find more details about what is going on?

  Thanks.

• karthik babu

  Hall of Fame

  Points: 3335

  More actions

  January 9, 2018 at 8:40 am

  #1975090

  I got the same warning and error. Please let me know the solution if you did solve it. 

  Many thanks in advance.

  ______________________________________________________________Every Problem has a Solution; Every Solution has a Problem: 🙂