|
|
Posted by Benzine on 12/21/06 05:34
I recently rolled out replication on our production server (MS SQL 2000
SP4) and every time a subscriber tries to sync the following always
appears in the Merge Agent History:
"Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0
conflicts)"
Then at the very end of the "Action Messages" the following appears:
"Merged 31489 data changes (453 inserts, 30893 updates, 143 deletes, 14
resolved conflicts)."
Each sync always produces this large result. I don't understand what is
happening and why such a large amount of changes are suppose to be
happening. I could sync directly after the previous and get the same
result.
There are only 4 subscribers that merge with the publisher and all get
the same types of changes appearing.
Also MSmerge_contents table doesn't seem to be cleaned up after all
have synced, the table always contains approx 30000+ records.
Can anyone help please??
Navigation:
[Reply to this message]
|