Home > DeveloperSection > Forums > SQL server databases stuck in restoring state
Monaj Singh
Monaj Singh

Total Post:41

Posted on    September-09-2015 5:05 AM

 MSSQL Server Database  MSSQL Server 

 1 Reply(s)
 1256  View(s)
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?

Mayank Tripathi
Mayank Tripathi

Total Post:397

Posted on    September-09-2015 6:55 AM

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.

Don't want to miss updates? Please click the below button!

Follow MindStick