SQL Database State stuck in Restoring

27 Jul

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:


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


Posted by on July 27, 2012 in SQL


Tags: , , ,

3 responses to “SQL Database State stuck in Restoring

  1. Mihai

    June 30, 2014 at 20:09

    Hi Michael,

    Nice and concise article, but I want to make a few more additions to your post. Sometimes you might need to overwrite the data in order to be sure there are no data inconsistencies in the database.

    I have written an article about this where you can find a more detailed scenario of what could have happened and what were the solution I found.

    Anyway, 5 stars for your article from me and I will definetly be checking out your other articles as well!



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: