Share via

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

Sravanthi Godavarthy 20 Reputation points
2024-08-28T06:06:06.1966667+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,671 questions
0 comments
Accepted answer
  1. MikeyQiaoMSFT-0444 2,710 Reputation points
    2024-08-28T08:18:44.6033333+00:00

    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

    1. 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.
    2. 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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

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