Clustering and Transactions

Hi,
When the primary server fails and the secondary starts to take over the job,
what will happen to the transactions opened on the primary node prior to
failure?
Thanks,
Leila
They all get rolled back and every connection is severed. Your client code
should re-try.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
"Leila" <leilas@.hotpop.com> wrote in message
news:OXWJoSdwEHA.3336@.TK2MSFTNGP11.phx.gbl...
Hi,
When the primary server fails and the secondary starts to take over the job,
what will happen to the transactions opened on the primary node prior to
failure?
Thanks,
Leila
|||"Leila" <leilas@.hotpop.com> wrote in message
news:OXWJoSdwEHA.3336@.TK2MSFTNGP11.phx.gbl...
> Hi,
> When the primary server fails and the secondary starts to take over the
job,
> what will happen to the transactions opened on the primary node prior to
> failure?
You need to treat it just like one server was shut down and the other
started up.
Transactions are rolled back (or in a few cases forward) as appropriate.

> Thanks,
> Leila
>