Share via

Some availability replicas do not have a healthy role

  • Article

Introduction
Policy Name Availability Replicas Role State
Issue Some availability replicas do not have a healthy role.
Category Warning
Facet Availability group

Description

This policy rolls up the connection state of all availability replicas and checks if there are any availability replicas that are not in a healthy role. The policy is in an unhealthy state when any availability replica is neither primary nor secondary. The policy is otherwise in a healthy state.

Note

For this release of SQL Server 2014, information about possible causes and solutions is located at Some availability replicas do not have a healthy role on the TechNet Wiki.

Possible Causes

In this availability group, at least one availability replica does not currently have the primary or secondary role.

Possible Solution

Use the availability replica policy state to find the availability replica whose role is not primary or secondary, 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)