Database Stuck In Restoring Status

Owned by Knowledge Assistant
Feb 21, 2023
1 min read



Description of Issue

Fixing a database that is currently stuck in "Restoring" mode.



Context

  • SaaS

  • On-Premises

  • Databases

  • Cloud Admin

  • Munis

  • SSMS



Cause

Restoration of a backed up database has caused the original database to enter a "Restoring" status–causing the database and its associated connections to break.



Resolution

As a best practice, if possible, please ensure that a backup of each effected database has been taken.

  1. Log onto the database server housing the impacted database.

  2. Open and click SQL Server Management Studio (SSMS).

  3. Review the server name and click Connect.

  4. Click the New Query button. This should automatically open a query window that will be ran on the master database.

  5. Copy and paste the following query into the window, where <DatabaseName> is the database actively in a "Restoring" status.


    RESTORE DATABASE <DatabaseName> WITH RECOVERY


  6. Click Execute.

  7. Right click the Databases folder within SSMS and select the Refresh button.

  8. Verify that the database is no longer restoring, has been brought online, and that access to programs associated with the database has been re-instantiated.



Additional Information

SaaS clients will require support assistance to complete this task. Please reach out to our TSM Support division by creating a case within our portal.