June 25, 2013 at 6:08 am
Hi guys.
I wanted some clarification about snapshot replication. What happens when the snapshot replication is now in the middle of transferring data to the subscriber when the distribution agent job suddenly stops? What happens when I try to restart the synchronization again? Will it continue to transfer the data where it stopped? Or will it retransfer all of the data to the subscriber again?
I'm asking this since we have a snapshot replication that runs for a long time and in between that time, there's another job that will run but it is suspended maybe due to resources availability. I thought we could try to stop the replication process and let the other job complete. And then rerun the distribution agent again to continue with the replication.
Thank you
June 25, 2013 at 9:27 am
If the snapshot transfer is interrupted it will pick up where it left off. It will not resend the entire snapshot again. This is covered in Initialize a Subscription with a Snapshot.
If the snapshot transfer is interrupted at any point, it will automatically resume and will not resend any files that have already been completely transferred. The unit of delivery for the Snapshot Agent is the bcp file for each publication article, so files that are partially delivered must be completely redelivered. However, resuming the snapshot can significantly reduce the amount of data transmitted and ensure timely snapshot delivery even if the connection is unreliable.
June 26, 2013 at 7:16 am
Thank you Brandon for the answer.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply