SQL SERVER DATABASES STUCK IN RESTORING STATE

Monaj Singh

Total Post:41

Points:287
Posted by  Monaj Singh
 1286  View(s)
Ratings:
Rate this:
I have a Sharepoint server. I guess our network administrator has miss configured his back up tool (I guess he uses Symantec backup exec) and now some of my databases are stuck in restoring state!

How can I stop restoring process and also, is it possible to have these databases back working right?
  1. Mayank Tripathi

    Post:397

    Points:3117
    Re: SQL server databases stuck in restoring state

    This is likely caused by the restore script adding the WITH NO RECOVERY parameter to make the database ready for a transaction log apply after the restore. The database is now waiting for the latest transaction log file.

    You can either:

    Apply the latest transaction log (Using RESTORE LOG... WITH RECOVERY)... or
    Restore the database again, but this time using WITH RECOVERY ... or
    Force the database out of restoring mode by executing: RESTORE DATABASE YourDb WITH RECOVERY
    Before you do this, please make sure you understand the implications of these options. You may cause data loss if you are not careful.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!