clean up of MSmerge

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » clean up of MSmerge_history

clean up of MSmerge_history

Rate Topic

Display Mode

Topic Options

Author

Message

sierra4

Posted Friday, February 22, 2013 9:07 AM

SSC Rookie

Group: General Forum Members
Last Login: Today @ 5:50 AM
Points: 34, Visits: 420

Merge replication
SQL Server 2005 SP2

After server was restarted a couple of days ago the log for the distribution db suddenly grew and filled up the drive it was on.

After a couple of reinitializations and snapshot creations the subscriber is now synch'd with the publisher, however, the log utilization for the distribution db is constantly reaching 100%.
It looks like the activity is coming from the job "Agent history clean up : distribution".
The job is scheduled to run every 10 min but it does not complete successfully and would fail once in a while because the log is full (log size is 50 GB, db size is 20 GB).
The oldest entry in the history log is from 3 days ago so I'm thinking the job hasn't been running the past couple of months.

The query shows:
select count(*) from MSmerge_history; 46,868,507 rows

The min(time) in MSmerge_history is 2012-06-29 21:07:35.160

My question is, can we directly clean up the MSmerge_history table with a delete statement?
What are the risks?

distribution db is in SIMPLE mode.

thank you

Post #1423115

« Prev Topic | Next Topic »

Permissions