one issue about transactional replication in SQL Server 2008.

• Wison

  SSC-Addicted

  Points: 425

  More actions

  February 4, 2013 at 12:51 am

  #273668

  Hi all,

  There is one problem about transactional replication in SQLServer 2008.

  After configuring the replication, there will be three jobs 'Distribution clean up:distribution','Agent history clean up:distribution' and 'Replication agents checkup'.

  When the 'Distribution clean up:distribution' job ran, it blocked the other two jobs 'Agent history clean up:distribution' and 'Replication agents checkup'.

  Then, it made the replication latency very high.

  After I stopped this job, the other two jobs would run very quickly. And the synchonization was normal.

  How can I fix the issue?

  Appreciate your kindly response.

• Query Shepherd

  SSCrazy

  Points: 2988

  More actions

  February 7, 2013 at 6:50 am

  #1585408

  Seems like the distribution is not cleaned up!

  Check the retention days for each subscription. It should not be configured as "never expires"!

  Greetz
  Query Shepherd