Unix Technical Forum

Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts)

This is a discussion on Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts) within the SQL Server forums, part of the Microsoft SQL Server category; --> I recently rolled out replication on our production server (MS SQL 2000 SP4) and every time a subscriber tries ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-01-2008, 11:53 AM
Benzine
 
Posts: n/a
Default Downloaded 100 data changes (0 inserts, 100 updates, 0 deletes, 0 conflicts)

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??

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 02:13 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com