Secondary database is not joined
Introduction
Policy Name |
Availability Database Join State |
Issue |
Secondary database is not joined. |
Category |
Warning |
Facet |
Availability database |
Description
This policy checks the join state of the database replica. The policy is in an unhealthy state when the dataset replica is not joined. The policy is otherwise in a healthy state.
Possible Causes
This secondary database is not joined to the availability group. The configuration of this secondary database is incomplete.
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).