RSS

Tag Archives: database

SQL Database State stuck in Restoring

If you have the issue that your database state stuck in the restoring state forever, then you have to execute a single command. Without executing you will not be able to access a database in the restoring state. Execute following command:

RESTORE DATABASE DatabaseName WITH RECOVERY

Then your state will change again back to Normal and you can access the database again.

 
3 Comments

Posted by on July 27, 2012 in SQL

 

Tags: , , ,