sql server transaction replication

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » sql server transaction replication - run...

sql server transaction replication - run continuously

Rate Topic

Display Mode

Topic Options

Author

Message

luckysql.kinda

Posted Monday, November 23, 2009 12:08 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 11:19 AM
Points: 309, Visits: 645

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

dba_pkashyap

Posted Monday, November 23, 2009 3:23 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 06, 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

VRR

Posted Monday, November 23, 2009 10:18 AM

SSC 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 »

Permissions