How do I find the progress of a detach job?
Posted on 2010-11-10
Using SQL Management Studio, I ran a detach command against a SQL 2000 database.
Tha databse is large and consists of 3 files.
When I've done this to other databases to relocate them on the server, usually a detach takes just a few minutes.
This one has taken over 3 hours now.
I've tried to find a method to see what its doing, but I cannot find a way to tell. I just see that green circle spinning and the word "Executing"
I noticed int he Activity Monitor I have the option to Kill the Process, but I'm not sure how harsh that would be to the database at this point.
Is it safe to kill the process and try again another time?
How can I find out exactly what progress has been made?