MSSQL: How to Get Database Out of “Restoring” State

When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this.
Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code below with the database you want to restore.
RESTORE DATABASE YourDatabase
FROM DISK = ‘D:\YourDatabase.bak’
WITH REPLACE,RECOVERY
The database will then be restored and ready to use.

Leave a Comment