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

one issue about transactional replication in SQL Server 2008. Expand / Collapse
Posted Monday, February 4, 2013 12:51 AM


Group: General Forum Members
Last Login: Thursday, March 12, 2015 12:49 AM
Points: 23, Visits: 143
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.
Post #1415141
Posted Thursday, February 7, 2013 6:50 AM



Group: General Forum Members
Last Login: Monday, March 2, 2015 3:18 AM
Points: 133, Visits: 437
Seems like the distribution is not cleaned up!

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

Query Shepherd
Post #1417047
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse