Resources For IT Professionals

United States (English) Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by Joseph Sack (eMVP, Microsoft Partne)
When: 6 Jun 2011 8:44 PM
Last revision by Margi.Showman
When: 24 Oct 2011 5:15 PM
Revisions: 3
Comments: 1

Options

Subscribe 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.

Data synchronization state of availability database is not healthy.

Introduction

Policy Name	Availability Database Data Synchronization State
Issue	Data synchronization state of availability database is not healthy.
Category	Warning
Facet	Availability database

Description

This policy rolls up the data synchronization state of all database replicas in the availability replica. The policy is in an unhealthy sate when any database replica is not in the expected data synchronization state. The policy is otherwise in a healthy state.

Possible Causes

The data synchronization state of this availability database is unhealthy. On an asynchronous-commit availability replica, every availability database should be in the SYNCHRONIZING state. On a synchronous-commit replica, every availability database must be in the SYNCHRONIZED state.

Possible Solution

Use the database replica policy to find the database replica with an unhealthy data synchronization state, and then resolve the issue at the database replica.