Availability database is suspended for an availability group
Applies to: SQL Server
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.
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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho