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?
mfpenaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rjbookCommented:
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.
0
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?
Thanks
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.