February 14, 2009 at 7:47 am
I had to rebuild snapshot replication on one of my production databases after an application upgrade. I took the opportunity to move the distributor off the publishing server and put it on the subscribing server since it has virtually no traffic during our replication window as it is only used for reporting.
Anyway from looking at my replication monitor logs, the snapshot appeared to be cruising right along nicely until a certain point where it started giving the following message:
[98%] The process is running and is waiting for a response from the server. 2/14/2009 3:22:55 AM
And continued to put out that message until I had to kill the job at 8:12 AM.
At this point in the creation of the snapshot, the job had just finished bulk copying the largest table of 63million rows, and that is when the error message started appearing.
Is there a way I can find out what was causing the wait? Or how to resolve this issue so the replication job will finish?
I suspect that all of the other tables had finished with thier bulk copy as that particular table was the last one generating messages for quite some time. Apparently the replication job appears to be multithreaded, as it was doing more than one table at a time according to the replication monitor's agent history.
February 18, 2009 at 8:19 am
This message tends to happen at index creation time after the data has been transferred by the snapshot job
* Noel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply