SQL Server 2005 db Hangs in Restore mode

I restored a 61 gig db yesterday which normally takes no longer than a few hours. I check back today 15 hours later and the database states that it's still in the restore mode. What would be the best approach to correct this?
Who is Participating?
sbagireddiConnect With a Mentor Commented:
I do not see any problem with deleting the database and restarting the restore from the beginning.
SasDevAuthor Commented:
If I delete the database will it also delete the backup associated with it?
No it will not.

You can issue this command:

DROP DATABASE [AdventureWorks]

If it does not drop it, you may have to kill the specific spid in the Acticity Monitor.

SasDevAuthor Commented:
Thanks for the advice. That worked fine.
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.