Some availability replicas are disconnected
Applies to: 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 DISCONENCTED. 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)