RSS

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:

RESTORE DATABASE DatabaseName WITH RECOVERY

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

Advertisements
 
3 Comments

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!

    Regards,
    Mihai

     

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: