one issue about transactional replication in SQL Server 2008.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » one issue about transactional replication in...

one issue about transactional replication in SQL Server 2008.

Rate Topic

Display Mode

Topic Options

Author

Message

Wison

Posted Monday, February 04, 2013 12:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 7:49 PM
Points: 8, Visits: 61

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

SQL Pizza

Posted Thursday, February 07, 2013 6:50 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:14 AM
Points: 116, Visits: 293

Seems like the distribution is not cleaned up!

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

Greetz
SQL Pizza

sometimes you dont see the pizza for the toppings...
seek and ya shall find...

Post #1417047

« Prev Topic | Next Topic »

Permissions