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.
OR
The User forget to include WITH RECOVERY with Restore script.
Solution:
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).
This usually occurs when a user who initiated the restore, was disconnected during the restore process and leaves the restore process.
OR
The User forget to include WITH RECOVERY with Restore script.
Solution:
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