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

By on December 17, 2019

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 Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: