Monday, December 2, 2013

Database Stuck In Restoring State

Sometime, You may found a database that is restoring mode after so many hours and after refresh also, the database is still restoring.

This usually occurs when a user who initiated the restore, was disconnected during the restore process and leaves the restore process. 
The User  forget to include WITH RECOVERY with Restore script.

Run RESTORE DATABASE [Database_Name] WITH RECOVERY  to complete roll forward. 
If this failed, than you may have to drop the database and restoring from backup 
(make sure you include RECOVERY in your restore script this time).

No comments:

Post a Comment