• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1533
  • Last Modified:

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?
0
SasDev
Asked:
SasDev
  • 2
  • 2
1 Solution
 
sbagireddiCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now