conflict_<PublicationName>_<ArticleName>
all,
we have merge replication running on sql server 2008...we have retention period set 14 days..but the conflict_<publicationname>_<articlename> table data not deleted regularly. see conflicts data past 6 months..merge replicaion not cleaning conflicts table....
any suggestions...tia
the metadata cleanup in merge replication doesn't cleanup conflict tracking tables. need periodically review conflicts in conflict viewer reduce size of conflict tracking tables.
if have lot of conflicts, can write purge script.
repltalk has article on clearing resolved merge replication conflicts.
sqlrepl.com
SQL Server > SQL Server Replication
Comments
Post a Comment