How to terminate a failed backup
Posted on 2012-03-28
We are using SQL server 2008. Today during a restore the server ran out of disk space. After the Sys Admin remidied that problem, another problem still exists. The database still thinks it is being restored. The word "Restore" appears in parenthesis next to the databases name in SSMS.
I have a good backup copy (Actually I was trying to overwrite this databalse with backup from another database). How do I stop the failed restore?
Can I stop SQL server, delete the MDF and LDF and restart the service? What is the best method to fix this mess.