May 15, 2009 at 3:18 pm
Our client has SQL Server 2000 sp4 installed on publisher, distributors and subscribers. We have a big issue now. Date change on distributors can not be merged into subscribers after the first time merge unless reinitialization. Here is what we did after initialization:
1) changed value in a field on distributor.
2) Started merge job. The data changed were pulled to subscribers.
3) Changed value again in the same field on distributor.
4) Started merge job. This time, the data were not pulled to subscribers (data on subscribers remained unchanged). But, strange thing is that merge agent history showed 1 updates. After first time merge, we can push data to subscribers only by initialization again.
We never had this issue if client only has publisher and subscribers. This issue only occurred after distributors were added. Another strange thing is that this issue did not occur between distributor and publisher, only between distributor and subscriber.
Thanks for help.
May 21, 2009 at 1:25 pm
Looks like that column you made changes is filtered... check
publiser->Property-> filter.
hth.
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
May 26, 2009 at 4:18 pm
Vinay,
Thank you for your reply.
I checked our database. The column is not filtered. Actually, all columns have the same problem.
Regards,
-Ming
May 28, 2009 at 5:21 am
ming_dong (5/15/2009)
We never had this issue if client only has publisher and subscribers. This issue only occurred after distributors were added. Another strange thing is that this issue did not occur between distributor and publisher, only between distributor and subscriber.
Thanks for help.
I don't understand really what you're saying here. Replication without a distributor does not exist.
The distributor is always necessary to keep track of the replication status and to manage the synchronization.
With merge replication the distribution database only holds status information. Under normal ciscumstances you would never do any updates on the distributor, only on the publisher and the subscribers.
Could it be that you're talking about re-publishing, there one server is subscriber and publisher at the same time? In that case your problem is most likely related to the conflict resolution. Check in conflict viewer to see what is going on.
[font="Verdana"]Markus Bohse[/font]
May 29, 2009 at 4:06 pm
Sorry for confusing you. Yes, what I was talking is about re-publishing. I checked conflict. No any conflict occurred.
Thanks,
-Ming
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply