How do I find the progress of a detach job?

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?

Thanks.
jvleigh221Asked:
Who is Participating?
 
jvleigh221Author Commented:
Update: 4hrs now and the database finally detached.
As I was looking in the Activity Monitor I found several time the job was waiting with PAGEIOLATCH_SH.
Evidently this may point to a disk issue. Thus the processing time was significantly impacted.
In moving the files to their new location on the same server, just a different drive letter, I'm experiencing file transfer times way beyond normal. 20GB file from one drive letter to another - 45minutes.
Something is slowing the disk down.
Anyway, thanks to all who came across this question. I would still love to know the answer to the original question, but now that the issue is in a different phase I fell I should close the question.
 
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.