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.
| Author |
Topic |
|
AlexGeltermair
Starting Member
1 Post |
 Posted - 2009-12-11 : 09:50:27
|
| Hello, we setup up an peer-to-peer replication with SQL 2008. the system consists of two physical servers with one database server instance and four databases on each. for each database we replicate each table with peer-to-peer.the replication works fine. we change data at one server and it is replicated to the other. but if we delete two rows, insert same row's again and update them on one server we get an conflict. In the conflict the originator id of source and destination is the same. We configured every publication with it's own unique originator id. So it's seem to be a conflict from server 1 to server 1!How it's possible to get a conflict if I only change data at one server? I thought it's only possible if I change the same row on two server's at the same time?thanks for helpingalexander |
|
|
|
|
|
P-t-P Conflict PeerI