I've set up Merge replication between mutliple publishers and one central
subscriber. The problem I am getting is that records are intermittently
being deleted from the publishers for no apparent reason. I am filtering the
data from the publishers, each article in the publications contains a field
called site_code which is an integer. This field uniquely identifies each
site. The records are being deleted, they are not in the conflict tables,
and no conflicts are being raised by the system.
I have set up the replication as a series of Pull subscriptions staggered by
half an hour for each publisher. The publishers are running SQL 7.0 Desktop
Edition and the Subscriber is SQL 7.0 Enterprise, all with SP3 applied. Has
anyone come across a similar problem or know if this is a bug? Any help will
be greatly appreciated.