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: Tuesday, April 14, 2015 8:29 PM
Points: 23, Visits: 145
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: 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"!


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

Add to briefcase

Permissions Expand / Collapse