Ask the Community
Groups
SQL database is stuck in the "Restoring..." status - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>This article discusses how to fix a SQL database restore issue where the SQL database gets stuck in the “Restoring…” status.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="purpose">Purpose</h3> <p>This article discusses how to fix a SQL database restore issue where the SQL database gets stuck in the “Restoring…” status.</p> <h3 data-id="symptoms-description">Symptoms / Description</h3> <p>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.</p> <h3 data-id="resolution">Resolution</h3> <p>One method that may be used to resolve this is to remove and restart the SQL database using the following steps.</p> <ol><li>Detach the SQL database in SQL Studio Manager.</li> <li>Remove the SQL database showing a status of “Restoring…”.</li> <li>Perform a new restore of the desired SQL database using the Unitrends system.</li> </ol> </article> </main>