Merge Groundhog Day

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

peetyport@gmail.com - 29 Aug 2006 19:56 GMT

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

Reply to this Message

Hilary Cotter - 29 Aug 2006 21:18 GMT

Can you run some validations to determine if everything is synchronized. Its
unclear to me whether this is a problem or not.

Signature

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

> I have merge replication running with the following topology:
>
[quoted text clipped - 13 lines]
> Kind Regards,
> Stephen

Reply to this Message

peetyport@gmail.com - 30 Aug 2006 00:28 GMT

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....... :-(

> Can you run some validations to determine if everything is synchronized. Its
> unclear to me whether this is a problem or not.

Reply to this Message

Hilary Cotter - 30 Aug 2006 02:07 GMT

If it passes validation it is synchronized. Run profiler to determine what
is being downloaded.

Signature

> I believe I validated my subscription successfully. In Replication
> Monitor, I right-clicked and selected "Validate All Subscriptions". I
[quoted text clipped - 8 lines]
>> Its
>> unclear to me whether this is a problem or not.

Reply to this Message