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.