Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

3 Publications from one Database to 1 subscriber Expand / Collapse
Posted Wednesday, November 18, 2009 11:39 AM


Group: General Forum Members
Last Login: Friday, October 14, 2011 2:01 PM
Points: 11, Visits: 183
I have 3 Transactional Replication publications configured on Server A, we have configured 3 publications for administrative reasons dividing articles into 3 publications.
We have subscriber B that is the subscriber for Server A. we have combined 3 Tran. Repl. jobs into 1 so that only 1 job updates the Subscriber.
Server A to Server B using 3 publications with 1 job (Log Reader)

Sometimes we are seeing that the from Publication B - T2 transaction is reaching before Transaction T1 from Publication A, even when we send T1 then T2.

How can we address this ?
Please help gurus
Post #821049
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse