Recover database in “Restoring…” mode

Here is the sql to run when your database is in restoring mode.

restore database Budgets with recovery

You should know why your database is in restoring mode to begin with before running. For me, it’s typically because I left the db in no recovery mode after I restored a backup.

This entry was posted in SQL. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">