CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • Data synchronization state of some availability database is not healthy.

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    231
  • Date Created
    Thursday, May 21, 2020
  • This Article Has been Viewed
    710 times
  • Short Desc
    Always On High Availability Group wizard if not correctly setup will cause the error to happen. Make sure you properly set up all SQL Server replicas for the group to function correctly.
  • Details
     

    Detected Issue
    Data synchronization state of some availability database is not healthy.
    Description
    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.
  • Recreate Issue
    When running the [Always On High Availability Group] Wizard, the servers were improperly setup, and this caused the errors to happen. Unless you correctly setup [Always On High Availability Group] this error will continue to show, even after running the [Resolve Issue] below.
  • Resolve Issue
    For each of the SQL Instances
    Right-Click and choose [New Query]
    For each database in the SQL Instance, run this command.
    (Change DB_Name to each of your database names, and the SQLGroup, to the name of your SQL Group Name)

    ALTER DATABASE DB_Name-1 SET HADR AVAILABILITY GROUP = SQLGroup
    ALTER DATABASE DB_Name-2 SET HADR AVAILABILITY GROUP = SQLGroup
    ALTER DATABASE DB_Name-3 SET HADR AVAILABILITY GROUP = SQLGroup
    ALTER DATABASE DB_Name-4 SET HADR AVAILABILITY GROUP = SQLGroup

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles