merge repl conflict not showing in conflict viewer

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

merge repl conflict not showing in conflict viewer

Author

Topic

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2010-12-02 : 15:27:27

Hello Every body. I am writing after a long time. I have one fail over clustered server as a Publisher and 20 Subscriber with merge replication (Push Subscription). The Publisher and the subscriber have got the same version of SQL Server 2005 with SP2. We are facing the following problem which is needed to be solved urgently.
1. Conflict type 4 (Update/Delete Conflict) not showing in conflict viewer where the subscriber should win. (delete should win but now publisher is winning).

2. Conflict type 1 (Update Conflict) not showing in conflict viewer where the subscriber should win. (Subscriber should win but now publisher is winning).

Please tell me the reason if anyone knows and what is solution?

One thing should be told. All the subscribers had sql 2000 and the publisher was sql 2005. After Migrating we kept the snapshot which was taken before for sql server 2000 subscribers. Is it a possible cause for creating such problems? Another is that, if we add a new subscriber without taking a new snapshot, the problem is rapidly increasing. Please give me a solution or otherwise I am going to be mad..........Please help me dear ones.

fazle rabbee

fazle_rabbee
Yak Posting Veteran

63 Posts

Posted - 2010-12-04 : 03:32:35

Please need the solution. I will be ever grateful to u.

fazle rabbee