| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
Secondary database is not joined |
Availability Database Join State checks the join state of the secondary database as part of policy based management for Always On availability groups. |
MashaMSFT |
mathoma |
05/17/2016 |
sql |
availability-groups |
reference |
|
|
[!INCLUDE SQL Server]
- 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.
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 Always On Availability Groups (SQL Server)
Use the Always On Dashboard (SQL Server Management Studio)