SQL Database State stuck in Restoring

27Jul

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.