Skip to content

Latest commit

 

History

History
46 lines (37 loc) · 2.38 KB

File metadata and controls

46 lines (37 loc) · 2.38 KB
title Availability replica is not joined to an availability group
description Identify possible reasons why a replica is not joined to an Always On availability group.
ms.custom seodec18
ms.date 05/17/2016
ms.prod sql
ms.reviewer
ms.technology high-availability
ms.topic conceptual
f1_keywords
sql13.swb.agdashboard.arp4joined.issues.f1
helpviewer_keywords
Availability Groups [SQL Server], policies
ms.assetid 9c0d10b1-9e12-430c-83b9-ca2bd0a3afc4
author MashaMSFT
ms.author mathoma

Availability replica is not joined to an Always On availability group

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

Introduction

Policy Name Availability Replica Join State
Issue Availability Replica is not joined.
Category Warning
Facet Availability replica

Description

This policy checks the join state of the availability replica. The policy is in an unhealthy state when the availability replica is added to the availability group, but is not joined properly. The policy is otherwise in a healthy state.

Note

For this release of [!INCLUDEssCurrent], information about possible causes and solutions is located at Availability replica is not joined on the TechNet Wiki.

Possible Causes

The secondary replica is not joined to the availability group. For an availability replica to be successfully joined to the availability group, the join state must be Joined Standalone Instance (1) or Joined Failover Cluster (2).

Possible Solution

Use Transact-SQL, PowerShell, or SQL Server Management Studio to join the secondary replica to the availability group. For more information about joining secondary replicas to availability groups, see Joining a Secondary Replica to an Availability Group (SQL Server).

See Also

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