Groups | Blog | Home
all groups > sql server replication > may 2007 >

sql server replication : Merge Replication to multiple servers losing data


PaulW
5/15/2007 1:05:10 PM
Hi,

We are using merge replication between four servers (1 publisher & 3
subscribers). The same articles (tables) are in each publication. I run the
application which changes data in some tables and adds records in another
table. The inserted data is immediately updated via trigger. After running
the application all expected data is present. If I manually force
replication to each subscriber sequentially, all expected data is present.
If I run replication between the servers at the same time, the table to
which data was added will lose some data. The data lost was not the data
that was just added. We are running SQL Server 2000 SP3a on all servers. Any
ideas?

tia,
Paul

Grigoris Tsolakidis
5/17/2007 12:00:00 AM
Look at the 'view conflict' at replication monitor...
Ï "PaulW" <MSNewsGroup@Digi-Sol.com> Ýãñáøå óôï ìÞíõìá
news:urv9zNxlHHA.1216@TK2MSFTNGP03.phx.gbl...
[quoted text, click to view]

PaulW
5/17/2007 7:17:53 AM
There are no recorded conflicts. This table only has data inserted, then
updated through a trigger. We did view the transaction log. The only entries
with the table were the inserts we initiated followed by a delete/insert for
the trigger update.

Paul


[quoted text, click to view]

AddThis Social Bookmark Button