• Here is something I am curious about.

    Setting the option for sync with backup on the distribution database has no effect on latency by itself.

    Setting the option for sync with backup on the publication database can increase latency because transactions cannot be delivered to the distribution database until they have been backed up at the Publisher.

    So, if you set sync with backup on both the distribution and publication databases, does that further increase latency? The possible reason is because setting it on the distributor can increase the transaction log of the publisher. Then if the publisher has to backup a bigger log that would further increase latency. Am I correct in my thinking?

    Following that reasoning, I can understand how setting the option on both would further increase latency rather than just setting it on the publisher. That would leave answer 1 to be the only correct answer.

    Thanks