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
Author
Message
Posted Monday, February 4, 2013 12:51 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, October 17, 2014 8:25 AM
Points: 23, Visits: 142
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


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 27, 2014 6:28 AM
Points: 133, Visits: 431
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
Post #1417047
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse