SQL database is stuck in the "Restoring..." status

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.

  1. Detach the SQL database in SQL Studio Manager.
  2. Remove the SQL database showing a status of “Restoring…”.
  3. Perform a new restore of the desired SQL database using the Unitrends system.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us