Solved

cancel database detach

Posted on 2014-03-26
1
836 Views
Last Modified: 2014-03-26
I ran a detach of a database on an MS SQL server 2008 R2 and I selected the update statistics.. The problem is the database has been updating statistics for a while now and I need to bring the database back online.. Is it safe to kill the "update statistics" process?
0
Comment
Question by:diamondcomics
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39957239
".. Is it safe to kill the "update statistics" process"

Yes, and that should be immediate as there is nothing to ROLLBACK.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

776 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