Share via

When always on secondary database is goes in suspended mode? What could be the reasons? how can we fix if it goes frequently?

Sathish Chandra Bhanumurthy Mavuri 0 Reputation points
2024-11-12T11:32:24.24+00:00

When always on secondary database is goes in suspended mode? What could be the reasons? how can we fix if it goes frequently?

SQL Server | Other

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 31,621 Reputation points
    2024-11-13T01:29:18.4933333+00:00

    Hi @Sathish Chandra Bhanumurthy Mavuri

    See tis doc: Availability database is suspended for an availability group.

    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.

    Best regards,

    Cosmog

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.