SQL server databases stuck in restoring state I have a Sharepoint server. We had an issue with our backup tool and now some of my databases are stuck in restoring state!



Is it possible to stop the restoring process? and also, How can I make sure the database integrity has not been compromised?
This is likely caused by the restore script adding the WITH NORECOVERY 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 database_name FROM backup_device 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.

See this for details:


http://technet.microsoft.com/en-us/library/ms177446.aspx
https://stackoverflow.com/questions/520967/sql-server-database-stuck-in-restoring-state