SUMMARY
This article discusses how to fix a SQL database restore issue where the SQL database gets stuck in the “Restoring…” status.
ISSUE
Purpose
This article discusses how to fix a SQL database restore issue where the SQL database gets stuck in the “Restoring…” status.
Symptoms / Description
When many SQL databases are queued for restore simultaneously, the SQL service may have difficulty processing the number of request. When this occurs, a SQL database may get stuck in the “Restoring…” status. You will see this status when you login using the SQL Studio Manager to view the restored / partially restored SQL databases.
Resolution
One method that may be used to resolve this is to remove and restart the SQL database using the following steps.
- Detach the SQL database in SQL Studio Manager.
- Remove the SQL database showing a status of “Restoring…”.
- Perform a new restore of the desired SQL database using the Unitrends system.