Solved

SQL Server 2005 db Hangs in Restore mode

Posted on 2008-06-26
4
1,484 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
combine data in sql 1 29
SQL Query 2 56
SQL Server Degrading on Write 13 60
Move SQL 2005 Express to Server 2012R2 19 69
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now