Replicated Changes not distributing to all subscribers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Replicated Changes not distributing to all...

Replicated Changes not distributing to all subscribers

Rate Topic

Display Mode

Topic Options

Author

Message

Grinja

Posted Thursday, March 12, 2009 7:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 25, 2013 5:50 AM
Points: 133, Visits: 609

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. Crazy

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 »

Permissions