missing records from merge replication

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

missing records from merge replication

Author

Topic

DavidD
Yak Posting Veteran

73 Posts

Posted - 2009-05-14 : 01:24:26

Dear all,

We have recently installed SQL Server 2005 replication. Our companies reps telecommunicate to pick up each others data via web synchronization.
We have been having issues with data not being transferred correctly ie the rep enters the data and telecommunicates, but it does not transfer through to the head office publisher.
We have been running our old system in parallel, so the missing records can be seen by comparing the two databases at Head Office, and the numbers missing are small (~1.8% of records entered) but we cannot afford any data loss.
There appears to be no common theme to the missing data except for the fact that they occur in chunks eg All of one particular reps calls for one day will be missing, but we will have all of their calls for the week before and the week after. Issuing an update statement against that missing set causes them to come across as they should have.
There are no conflicts involved. Does anyone know of this problem and what could be causing it?

Regards
David

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-05-14 : 04:19:18

If you have a look at Conflict Viewer, what reasons does it give?

http://msdn.microsoft.com/en-us/library/ms189029(SQL.90).aspx