Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Killing SQL Database in Recovery mode

Status
Not open for further replies.
Jules10010

Jules10010

IS-IT--Management
Joined
Feb 6, 2002
Messages
8
Location
GB
Database is in recovery. Estimated time of completion (days)

Need to be able to stop recover and delete databsae so we can perform a restore.

How do you do it?

 
Sort by date Sort by votes
You could stop the sql server and see if you could delete the database then, or reboot the SERVER and stop sql server on boot up. The first method may take some time if your recovery has been running for some time since it may be rolled back.

Hope this helps.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MathiasB
  • Locked
  • Question Question
Parameterised sql server query
Replies
8
Views
889
Chriss Miller
C
Steve Yu
  • Locked
  • Question Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN
Replies
3
Views
886
Chris Miller
Chris Miller
gbaughma
  • Locked
  • Question Question
SQL Performance
Replies
11
Views
1K
pjw001
pjw001
Andrzejek
  • Locked
  • Question Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
882
SaltyTheFrog
SaltyTheFrog
V
  • Locked
  • Question Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
1K
Volvere
V

Part and Inventory Search

Sponsor

Back
Top