Skip to content

Latest commit

 

History

History
51 lines (41 loc) · 2.3 KB

File metadata and controls

51 lines (41 loc) · 2.3 KB
title Some availability replicas are not synchronizing data | Microsoft Docs
ms.custom
ms.date 05/17/2016
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
dbe-high-availability
ms.tgt_pltfrm
ms.topic article
f1_keywords
sql13.swb.agdashboard.agp4synchronizing.issues.f1
helpviewer_keywords
Availability Groups [SQL Server], policies
ms.assetid 3db6a569-e942-4321-a0dd-c4ab002087c8
caps.latest.revision 12
author MikeRayMSFT
ms.author mikeray
manager jhubbard

Some availability replicas are not synchronizing data

Introduction

Policy Name Availability Replicas Data Synchronization State
Issue Some availability replicas are not synchronizing data.
Category Warning
Facet Availability group

Description

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.

Note

For this release of [!INCLUDEssCurrent], information about possible causes and solutions is located at Some availability replicas are not synchronizing data on the TechNet Wiki.

Possible Causes

In this availability group, at least one secondary replica has a NOT SYNCHRONIZING synchronization state and is not receiving data from the primary replica.

Possible Solution

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.

See Also

Overview of Always On Availability Groups (SQL Server)
Use the Always On Dashboard (SQL Server Management Studio)