Please help - one of the Always on secondary database stuck in restoring mode, all other databases are in sync, what could be the issue and how to resolve it

Question

Please help - one of the Always on secondary database stuck in restoring mode, all other databases are in sync, what could be the issue and how to resolve it

Answer 1

Hi，Sravanthi Godavarthy

How long has the restoration status been ongoing?

1. Try removing the existing copy in restoration from AG and re-add the secondary node. Check if there are any hints in the errorlog of the primary node.
2. Try to estimate the remaining time for the restoration status, refer to the following link

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/availability-groups/troubleshoot-availability-group-database-reverting-state?source=recommendations

3. Perform a full backup of the primary database on the primary replica, restore the database from the backup on the secondary replica, and re-add the node.
4. Wait for the restoration to complete.

Regards

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.