SQL Server – Database Stuck in a ‘Restoring’ State
SQL Server – Database Stuck in a ‘Restoring’ State
Sometimes during a restore of a database in SQL Server the restoration process will hang in a ‘Restoring’ state. You will typically be able to tell if this is the case if the Database ‘icon’ within SQL Server Management Studio has a (Restoring…) annotation next to the Database name in the list view.
To fix this issue do the following:
1. Log into SQL Server Management Studio
2. Select the database with the issue.
3. Click the ‘New Query’ button.
4. Use the following SQL Command – (replace DatabaseName) >> Click ‘Execute’.
RESTORE DATABASE DatabaseName WITH RECOVERY
The following two tabs change content below.

Andy, Software Engineer
Andy is Software Engineer at Metaphorix
Latest posts by Andy, Software Engineer (see all)
- Configuring the Web Client for tablets (NAV 2013+) - January 18, 2017
- NAV Know How: Creating a test system - May 4, 2016
- Web Client Install – Fatal Error During Installation 1603 - April 28, 2016