Replicated Changes not distributing to all subscribers

• Grinja

  Hall of Fame

  Points: 3590

  More actions

  March 12, 2009 at 7:35 am

  #201552

  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.00SP2Standard Edition

  Subscribers (identical hardware) - SQL server 2000 - 8.00.2050SP4Standard Edition

  Merge Replication (push) with Continuous updates.