Post reply

sql server transaction replication - run continuously

  • November 23, 2009 at 12:08 am

    #136236

    When configuring synchronization schedule in the transaction replication this has a setting of 'Run Continuously'. I want to understand the duration after which the transaction logs would be transported from publisher to subscriber.

    -Lk

  • November 23, 2009 at 3:23 am

    #1082856

    It should be immediate.

    It can be even like 2 phase commit, first it commits in the subscribers and then in the publishers.

    pavan.

  • November 23, 2009 at 10:18 am

    #1083038

    Its immediate.Log Reader will tranfer the commands to subscriber immediately.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply