Re: What if replication time exceeds replication interval?

Thanks, you two, for your answers.

I discovered what happens myself when the replication time did exceed the interval several times last night. Turns out that the next replication just waits until the previous one is finished. So given a 20-minute refresh interval, a refresh starting at 12:00 and running for three hours will recur at 3:20. In my case, the 3-hour refresh is an anomoly, with 1 minute being the norm.

--Bob

burgess_at_sympatico.ca (Bob Burgess) wrote in message news:<df35b276.0307301121.6c813a15_at_posting.google.com>...
> We have about 150 tables replicated by simple one-way snapshot
> replication from snapshot logs on another machine. All snapshots are
> in a refresh group with an interval of 20 minutes.
>
> What happens if the replication time exceeds 20 minutes? Continuous
> refreshing? Errors?
>
> Thanks,
> Bob Burgess
Received on Fri Aug 01 2003 - 14:59:19 CDT