Redigera

Dela via

Some synchronous replicas are not synchronized

  • Artikel

Applies to: SQL Server

Introduction

  • Policy Name: Synchronous Replicas Data Synchronization State
  • Issue: Some synchronous replicas are not synchronized.
  • Category: Warning
  • Facet: Availability group

Description

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.

Possible Causes

In this availability group, at least one synchronous replica is not currently synchronized. The replica synchronization state could be either SYNCHRONIZING or NOT SYNCHRONIZING.

Possible Solution

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.

See Also

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