| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Availability replicas not synchronizing data |
Possible causes and resolutions for when one or more availability replicas in an Always On availability group are not synchronizing data with the primary replica. |
MashaMSFT |
mathoma |
05/17/2016 |
sql |
availability-groups |
reference |
|
|
[!INCLUDE SQL Server]
- Policy Name: Availability Replicas Data Synchronization State
- Issue: Some availability replicas are not synchronizing data.
- Category: Warning
- Facet: Availability group
This policy rolls up the data synchronization state of all availability replicas in the availability group and checks if the synchronization of any availability replica is not operational. The policy is in an unhealthy state if any of the data synchronization states of the availability replica is NOT SYNCRONIZING.
This policy is in a healthy state if none of the data synchronization states of the availability replica is NOT SYNCHRONIZING.
In this availability group, at least one secondary replica has a NOT SYNCHRONIZING synchronization state and is not receiving data from the primary replica.
Use the availability replica policy state to find the availability replica with a NOT SYNCHROINIZING 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)