| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Some synchronous replicas are not synchronized |
Describes some possible causes and solutions for when a synchronous replica is not synchronized for an Always On availability group. |
MashaMSFT |
mathoma |
05/17/2016 |
sql |
availability-groups |
reference |
|
|
[!INCLUDE SQL Server]
- Policy Name: Synchronous Replicas Data Synchronization State
- Issue: Some synchronous replicas are not synchronized.
- Category: Warning
- Facet: Availability group
This policy rolls up the data synchronization state of all availability replicas and checks for any availability replicas that are not in the expected synchronization state. The policy is in an unhealthy state when any asynchronous replica is not in a SYNCHRONIZING state and any synchronous replica is not in a SYNCHRONIZED state. The policy state is otherwise healthy.
In this availability group, at least one synchronous replica is not currently synchronized. The replica synchronization state could be either SYNCHRONIZING or NOT SYNCHRONIZING.
Use the availability replica policy state to find the availability replica with the incorrect synchronization state, and then resolve the issue at the availability replica.
Overview of Always On Availability Groups (SQL Server)
Use the Always On Dashboard (SQL Server Management Studio)