Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sql server transaction replication - run continuously Expand / Collapse
Author
Message
Posted Monday, November 23, 2009 12:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 11, 2014 12:39 PM
Points: 310, Visits: 659
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
Post #823108
Posted Monday, November 23, 2009 3:23 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 6, 2012 2:49 PM
Points: 140, Visits: 310
It should be immediate.
It can be even like 2 phase commit, first it commits in the subscribers and then in the publishers.


pavan.
Post #823156
Posted Monday, November 23, 2009 10:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 11, 2012 9:11 AM
Points: 48, Visits: 303
Its immediate.Log Reader will tranfer the commands to subscriber immediately.
Post #823374
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse