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?
LVL 1
SasDevAsked:
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.
0
 
SasDevAuthor Commented:
If I delete the database will it also delete the backup associated with it?
0
 
sbagireddiCommented:
No it will not.

You can issue this command:

DROP DATABASE [AdventureWorks]
GO


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


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