jvleigh221
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.
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.