Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Wednesday, May 20, 2015 11:56 PM
Points: 23, Visits: 151
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: Tuesday, December 1, 2015 7:54 AM
Points: 134, Visits: 454
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