Skip to content

Latest commit

 

History

History
38 lines (30 loc) · 1.78 KB

some-availability-replicas-are-disconnected.md

File metadata and controls

38 lines (30 loc) · 1.78 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords
Some availability replicas are disconnected
Possible causes and solutions for when your availability group replica is disconnected for an Always On SQL Server availability group.
MashaMSFT
mathoma
05/17/2016
sql
availability-groups
reference
sql13.swb.agdashboard.agp7allconnected.issues.f1
Availability Groups [SQL Server], policies

Some availability replicas are disconnected

[!INCLUDE SQL Server]

Introduction

  • Policy Name: Availability Replicas Connection State
  • Issue: Some availability replicas are disconnected.
  • Category: Warning
  • Facet: Availability group

Description

This policy rolls up the connection state of all availability replicas and checks for any availability replicas that are DISCONNECTED. The policy is in an unhealthy state when any availability replica is DISCONNECTED. The policy is otherwise in a healthy state.

Possible Causes

In this availability group, at least one secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.

Possible Solution

Use the availability replica policy state to find the availability replica that is DISCONNECTED, 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)