Transactions done twice during failover

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Avi - 27 Aug 2006 08:57 GMT

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

Reply to this Message

Hilary Cotter - 27 Aug 2006 17:33 GMT

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.

Signature

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

> Hi experts,
>
[quoted text clipped - 6 lines]
> Thanks a million,
> Avi

Reply to this Message