I have a situation where we do a daily snapshot replication to another server. However, if the snapshot for some reason is not ready by 6am, it needs to be skipped and the next day applied.
I can easily schedule the job to apply the snapshot to only run from 6pm to 6am. However, if the snapshot is late and created at 6:15am, when the job runs at 6pm, it will apply the 6:15am snapshot, then apply the new 5am snapshot. This
is unacceptable for this purpose.
I believe I can remove the record(s) from the distribution database. I am just not sure which ones to delete or update to stop the replication.
View Complete Post