Resources For IT Professionals

United States (English) Drop down arrow

Россия (Pусский)中国（简体中文）Brasil (Português)

Post an article

Wikis - Page Details

First published by Joseph Sack (eMVP, Microsoft Partne)
When: 6 Jun 2011 8:45 PM
Last revision by Maheshkumar S Tiwari
When: 13 Sep 2013 1:57 PM
Revisions: 3
Comments: 1

Options

Subscribe to Article (RSS)

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

Availability Replica Is not joined

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.

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).