Link to home
Create AccountLog in
Avatar of jvleigh221
jvleigh221Flag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of jvleigh221
jvleigh221
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer