forum

Home / DeveloperSection / Forums / SQL server databases stuck in restoring state

Ask Question

SQL server databases stuck in restoring state

Anonymous User263909-Sep-2015
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!
SQL server databases stuck in restoring state
How can I stop restoring process and also, is it possible to have these databases back working right?
mssql serverdatabase mssql server 
Updated on 09-Sep-2015
Anonymous User

Anonymous User

Follow
I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

09-Sep-2015
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.

Liked By