Re: communication error when test fail over

Tech-Archive recommends: Fix windows errors by optimizing your registry

A cluster failover is exactly the same as a shutdown and a restart. Users
will be disconnected. A cluster-friendly client application should
reconnect with minimum user intervention.

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



"anoni" <anoni@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:316C153A-BA62-437C-A9B2-AA4F36CB4AA9@xxxxxxxxxxxxxxxx
I like the sql cluster to failover without disconnect the users or the
users
would not even notice the failover. Yes. users are able to reconnect to
it.
But users would lose data if they disconnected and need reconnect while
the
server1 failover server2.
Is sql cluster server suppose to failover flawless?

Thanks.

"Linchi Shea" wrote:

Do you have retry logic built into your client app? You need to
re-connect to
the instance.

Linchi

"anoni" wrote:

I get microsoft odbc sql server driver tcp/ip sockets general network
error
and microsoft odbc sql server driver communication link faillure errors
when
I open our client app and while I did a cluster failover.

Any reasons.

Thanks.





.

Relevant Pages

  • Re: Database Mirror and Failover
    ... Database mirroring works either way depending on which mode you're in. ... not the failover part but rather the new client ... ADO/ODBC.NET) has cached both server names. ... Whether it's a new client connection or a re-started ...
    (microsoft.public.sqlserver.clustering)
  • Re: Veritas storage foundation HA for windows
    ... How about Veritas Storage Foundation "HA" for Windows? ... "If one of the servers or resources running on the server in a cluster ... a process known as failover." ...
    (microsoft.public.sqlserver.clustering)
  • Re: Failover
    ... real-time failover. ... smaller businesses that can't afford or maintain a server cluster. ... it's as easy as installing antivirus on your server. ... "Can't unix run windows and I can take ...
    (microsoft.public.windowsxp.general)
  • Re: Failover
    ... real-time failover. ... smaller businesses that can't afford or maintain a server cluster. ... Licenses cost $2,995 for each server in the mirror. ... Hey if he has $10K to set up mirroring, maybe he is a day trader and can/needs to afford it? ...
    (microsoft.public.windowsxp.general)
  • RE: Auto Failover (Primary Data Center) + DR (Secondar Data Center)
    ... continue to restore from the log backups after the mirroring failover. ... Try this to find if the log backup chain is broken by the database mirroring ... but I doubt the built-in log shipping setup will ... Primary Server goes down the log shipping also stop working. ...
    (microsoft.public.sqlserver.clients)