Rerunning snapshot should not be cleaning the tables.
@.conflict_retention governs how long the data will be kept in these tables before purging.
|||If I have data in the conflict tables and then execute the snapshot SQL Agent job the conflict tables are cleaned out. I have the @.conflict_retention value set to 90 days.The publication is a filtered merge publication.|||
Sorry I missed your earlier comment that this was SQL Server 2000.
This is a known issue in SQL Server 2000 and has been fixed in SQL Server 2005.
No comments:
Post a Comment