Solved

How do I find the progress of a detach job?

Posted on 2010-11-10
1
285 Views
Last Modified: 2012-05-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?

Thanks.
0
Comment
Question by:jvleigh221
1 Comment
 

Accepted Solution

by:
jvleigh221 earned 0 total points
Comment Utility
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

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now