Groups | Blog | Home
all groups > sql server replication > august 2006 >

sql server replication : Merge Groundhog Day



peetyport NO[at]SPAM gmail.com
8/29/2006 11:56:34 AM

I have merge replication running with the following topology:

SQL2K5(PUB)------->SQL2K5(REPUB/SUB)------->SQLExpress2K5(SUB)

So, I have a publication which is pulled by two
republishers/subscribers. My clients pull from one of the two
republishers. The articles are filtered by HOSTNAME(). Almost every
time a client synchronizes, it downloads the same number of updates.
If I make a change it correctly increments the number of updates; if I
make one change the clients will always download the same number of
updates + 1. I have dropped the publication numerous times and even
moved the parent publication to a new server. Any ideas on how to
tackle this problem would be immensely appreciated. My boss has issued
a "CODE RED"! :-)

Kind Regards,
Stephen
Hilary Cotter
8/29/2006 4:18:05 PM
Can you run some validations to determine if everything is synchronized. Its
unclear to me whether this is a problem or not.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

peetyport NO[at]SPAM gmail.com
8/29/2006 4:28:13 PM

I believe I validated my subscription successfully. In Replication
Monitor, I right-clicked and selected "Validate All Subscriptions". I
then syncronized my client. In the MSmerge_history table, there are
comments for each of my articles like "Validating article XXX". The
error_id for this record is 0.

Since then my client continues to download 855 records although no data
is being changed in publishing database or on my client....... :-(

[quoted text, click to view]
Hilary Cotter
8/29/2006 9:07:23 PM
If it passes validation it is synchronized. Run profiler to determine what
is being downloaded.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button