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@gmail.com> wrote in message
news:1156877793.936785.30820@i42g2000cwa.googlegroups.com...
>
> 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
>