SQL Server: Database stuck in “Restoring” state

Updated on     Kisan Patel

Problem:

SQL Server: Database stuck in “Restoring” state

Solution:

You need to use the WITH RECOVERY option, with your database RESTORE command, to bring your database work as part of the restore process.

This is of course only if you do not intend to restore any transaction log backups, i.e. you only wish to restore a database backup and then be able to access the database.

RESTORE DATABASE NameofDatabase
WITH RECOVERY

Note: Above command will roll forward your database and you will be not able to restore any other database after that.


SQL Server

Leave a Reply