| title | Secondary database is not joined | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 01/09/2019 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | high-availability | |
| ms.topic | conceptual | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 10817e5e-75fa-42dd-baa2-359bea3ad051 | |
| author | MashaMSFT | |
| ms.author | mathoma | |
| manager | craigg |
| Policy Name | Availability Database Join State |
| Issue | Secondary database is not joined. |
| Category | Warning |
| Facet | Availability database |
This policy checks the join state of the secondary database (also known as a "secondary database replica"). The policy is in an unhealthy state when the dataset replica is not joined. The policy is otherwise in a healthy state.
Note
For this release of [!INCLUDEssCurrent], information about possible causes and solutions is located at Secondary database is not joined on the TechNet Wiki.
This secondary database is not joined to the availability group. The configuration of this secondary database is incomplete.
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).
Overview of AlwaysOn Availability Groups (SQL Server)
Use the AlwaysOn Dashboard (SQL Server Management Studio)