Hi experts,

I'm running replication from SQL Server 2000 to Sybase. Whenever I do a
failover from one node to the other I get duplicate rows. That means that
certain transactions are done twice.

What can I do to avoid that?

Thanks a million,
Avi

I suspect you need to put a pk on the Sybase tables to prevent this from
happening. If it is happening on the log reader agent writing to the
distribution database this is a known issue. When I encounter this I delete
the offending rows from msrepl_transactions and msrepl_Commands and have the
log reader send them again.

You might also want to use the continue on data consistency error profile.

--
Hilary Cotter
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

[quoted text, click to view]