Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (eMVP, Microsoft Partne)
  • When: 6 Jun 2011 8:47 PM
  • Last revision by
  • When: 24 Oct 2011 5:17 PM
  • Revisions: 4
  • Comments: 2
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Data synchronization state of some availability database is not healthy.

Data synchronization state of some availability database is not healthy.

Data synchronization state of some availability database is not healthy.

Introduction

 

Policy Name

Availability Replica Data Synchronization State

Issue

Data synchronization state of some availability database is not healthy.

Category

Warning

Facet

Availability replica

 

Description

This policy checks the data synchronization state of the database replica. The policy is in an unhealthy state when the data synchronization state is NOT SYNCHRONIZING or the state is not SYNCHRONIZED for the synchronous-commit database replica.

 

Possible Causes

At least one availability database on the 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 issue can be caused by the following:

  • The availability replica might be disconnected.
  • The data movement might be suspended.
  • The database might not be accessible.
  • There might be a temporary delay issue due to network latency or the load on the primary or secondary replica.

 

Possible Solution

Resolve any connection or data movement suspend issues. Check the events for this issue using SQL Server Management Studio, and find the database error. Follow the troubleshooting steps for the specific error.

 

, , [Edit tags]
Leave a Comment
  • Please add 4 and 2 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 24 Oct 2011 5:17 PM

    Margi.Showman edited Revision 2. Comment: Corrected Wiki title

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 24 Oct 2011 5:17 PM

    Margi.Showman edited Revision 2. Comment: Corrected Wiki title

  • Posted by
    on 8 Nov 2012 9:34 AM

    Possible Solution section is very vague as to be helpful. Should provide additional links to prescriptive steps that are related to the possible causes that are listed in the previous section.

Page 1 of 1 (2 items)