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

Replicated Changes not distributing to all subscribers Expand / Collapse
Author
Message
Posted Thursday, March 12, 2009 7:35 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 12:59 AM
Points: 133, Visits: 616
Hi,
Is it possible to identify records that still need to be replicated to subscribers?

I have a stituation where some changes do not get replicated to all subscribers (one in particular). There are no conflicts in the conflict log.

For example a transaction is loaded on a subscriber - > replicated to publisher/distributer -> replicated to other subscribers except one.

This seems to happen at least once a week.

Thanks!

Setup:
Publisher/Distributor - SQLServer 2005 - 9.00.3054.00 SP2 Standard Edition
Subscribers (identical hardware) - SQL server 2000 - 8.00.2050 SP4 Standard Edition
Merge Replication (push) with Continuous updates.
Post #674218
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse