MsSQL: Database in restoring state

When a MsSQL database has a mirror and something goes wrong, the database can end up in a restoring state. To force a recover of the database use the following command:

  • restore database <database> with recovery

This will make the database go on line.

To delete the database, use the following command:

  • drop database <db>

This command will remove the database and database files.

Leave a Reply

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