Conflict data automatic cleanup -- sql server replication

zebra1024
11/10/2006 9:26:18 AM

I thought that was the parameter but my conflict tables seem to be
cleaned out each night even though this parameter is set to 14. Does
generating the snapshots clean out these tables also?

[quoted text, click to view]

Hilary Cotter
11/10/2006 9:53:19 AM

the default is every 14 days. You set it with @conflict_retention parameter
of sp_addmergepublication

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

zebra1024
11/10/2006 9:57:54 AM

I just tested this and apparently generating the snapshots does clean
out the conflict tables.

[quoted text, click to view]

Paul Ibison
11/10/2006 2:50:22 PM

From BOL: "The Merge Agent deletes data from the conflict table if it is
older than the conflict retention period for the publication, which is
specified using the @conflict_retention parameter of sp_addmergepublication
(the default is 14 days)."
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Paul Ibison
11/10/2006 6:01:39 PM

Very interesting - thanks for the update. I'll request a BOL update for
this, as it is not mentioned in the right place (if at all).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server replication

sql server replication : Conflict data automatic cleanup