cyprich.com

By

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 Reply

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