Availability database is suspended

Introduction

Policy Name Availability Database Suspension State
Issue Availability database is suspended.
Category Warning
Facet Availability database

Description

This policy checks the state of data movement of the secondary database (also known as a "secondary database replica"). The policy is in an unhealthy state when the data movement is suspended. The policy is otherwise in a healthy state.

Note

For this release of SQL Server 2017, information about possible causes and solutions is located at Availability database is suspended on the TechNet Wiki.

Possible Causes

Data synchronization on this availability database might have been suspended because of the following:

  • Due to an error, the system might have suspended data synchronization.

  • The database administrator might have suspended data synchronization for maintenance purposes.

Possible Solution

Resume data synchronization. If the issue persists, check the availability group in the Event log, and then diagnose why the system suspended data movement.

See Also

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