Skip to content

Latest commit

 

History

History
45 lines (36 loc) · 1.86 KB

File metadata and controls

45 lines (36 loc) · 1.86 KB
title Some availability replicas are disconnected | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology high-availability
ms.topic conceptual
f1_keywords
sql12.swb.agdashboard.agp7allconnected.issues.f1
helpviewer_keywords
Availability Groups [SQL Server], policies
ms.assetid aea808be-6f0f-40c2-9aa2-a2a435ec6443
author MashaMSFT
ms.author mathoma
manager craigg

Some availability replicas are disconnected

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 DISCONENCTED. The policy is in an unhealthy state when any availability replica is DISCONNECTED. The policy is otherwise in a healthy state.

Note

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

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 AlwaysOn Availability Groups (SQL Server)
Use the AlwaysOn Dashboard (SQL Server Management Studio)