Failover with replication
- From: "Avi" <m@xxxxx>
- Date: Thu, 24 Aug 2006 19:09:31 +0300
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
.
Relevant Pages
- Replication during Cluster Failover
... I'm running replication from SQL Server 2000 to Sybase. ... failover from one node to the other I get duplicate rows. ...
(microsoft.public.sqlserver.replication) - Transactions done twice during failover
... I'm running replication from SQL Server 2000 to Sybase. ... failover from one node to the other I get duplicate rows. ...
(microsoft.public.sqlserver.clustering) - Re: Failover with replication
... I'm running replication from SQL Server 2000 to Sybase. ... failover from one node to the other I get duplicate rows. ...
(microsoft.public.windows.server.clustering) - Re: Clustering with 2 active nodes and 1 passive node
... Mike Epprecht, Microsoft SQL Server MVP ... >> If you have 2 nodes, one sits around waiting for a failover. ... >>> we are being asked to setup a 2 active node, 1 passive node environment. ...
(microsoft.public.sqlserver.clustering) - Re: Does Sybase have something like Oracles RAC for hot failover?
... between the Sybase capability and that of Oracle's RAC. ... Sybase HA failover is more equivalent to Oracle's DataGuard failover. ... With Oracle all existing client connections are maintained. ...
(comp.databases.sybase) |
|
