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.

FROM DISK = ‘D:\YourDatabase.bak’

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: