Solved

SQL Server 2005 db Hangs in Restore mode

Posted on 2008-06-26
4
1,513 Views
Last Modified: 2008-06-26
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
Comment
Question by:SasDev
  • 2
  • 2
4 Comments
 
LVL 8

Accepted Solution

by:
sbagireddi earned 500 total points
ID: 21877144
I do not see any problem with deleting the database and restarting the restore from the beginning.
0
 
LVL 1

Author Comment

by:SasDev
ID: 21877162
If I delete the database will it also delete the backup associated with it?
0
 
LVL 8

Expert Comment

by:sbagireddi
ID: 21877198
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
 
LVL 1

Author Comment

by:SasDev
ID: 21877292
Thanks for the advice. That worked fine.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Passing value to a stored procedure 8 110
Parse this column 6 34
SQL works but want to get the XML node data separately 11 26
Applying Roles in Common Scenarios 3 16
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question