Re: Failover from client POV

#1

A failover is exactly the same as an unexpected SQL server stop and restart
as far as the client can tell. So, all connections are lost for a brief
time, any transactions are rolled forward or back depending on their commit
status. The client needs to detect the connection failure, reconnect the
SQL, and resubmit any failed transactions.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"J Jetson" <JJetson (AT) discussions (DOT) microsoft.com> wrote

Quote:

When an instance fails over in a cluster from Server A to Server B, does
the client detect the outage or lose any information if it's in the middle

of a transaction? Or does SQL Server remember the transaction, rollback the
database, fail over the instance and restart the transaction? Thanks.

#2

No, it has to be coded by the application developers.

--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike (AT) epprecht (DOT) net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Quote:

A failover is exactly the same as an unexpected SQL server stop and
restart
as far as the client can tell. So, all connections are lost for a brief
time, any transactions are rolled forward or back depending on their
commit
status. The client needs to detect the connection failure, reconnect the
SQL, and resubmit any failed transactions.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"J Jetson" <JJetson (AT) discussions (DOT) microsoft.com> wrote in message
news:C2AA9B4B-71B8-42F8-BDEE-76ED2562F019 (AT) microsoft (DOT) com...
When an instance fails over in a cluster from Server A to Server B, does
the client detect the outage or lose any information if it's in the middle
of a transaction? Or does SQL Server remember the transaction, rollback
the
database, fail over the instance and restart the transaction? Thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Failover from client POV

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Re: Failover from client POV - 08-02-2004 , 02:53 PM

Re: Failover from client POV - 08-02-2004 , 06:42 PM