MS SQL 2005 restore failed now databse is hung in restoring state

I attempted to restore an MS SQL 2005 database using Symantec Backup Exec, the data base was small, 85Mb, however the restore was takng too long and the restored byte count was well over the database size, so it was obious that someting was not right,
So, I decided to cancel the restore, Backup exec cancelled the job, but now the databse is not accessible and shows being restored.

How may I recover from this state?
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
When you cancel restore process in the middle, database will go to Unrecoverable state.

To bring back database to Online, you have to restore again and dont disturb the process during restore process.
I have not used that particular product but one thing you may want to try is to restore the Symantec backup under a different database name to see if successful. If not then you probably have a corrupt backup. If it does restore successfully under a different name then you should be able to rename that database after dropping the hung version. This may (or may not) require a stop of SQL Server if you have to delete the files manually. Just a suggestion.
mfpenaAuthor Commented:
Thanks for your reply, I may not  have been clear in my question, my major concern is that the database is in a hung state, what is the proper procedure to recover from a hung state? stop /restart the SQL server?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.