Re: Will failover be triggered by failure of fibrechannel HBA?

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 11:34:11 -0400

Yes. A clustered SQL instance depends on many resources, one of which is
the physical disk(s) the data is stored on. Losing connectivity to the disk
will cause that resource and all resources that depend on it to fail. That
will trigger a cluster failover. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alec Waters" <alec.waters@NdatalineO.ScoP.AukM> wrote in message
news:4162b661$0$14212$afc38c87@news.easynet.co.uk...
> Hi all,
>
> Assume I have a two node Windows 2003/SQL Server 2000 cluster, with each
> node connected to a SAN via a single fibrechannel HBA.
>
> Will failover be triggered upon failure of the active node's HBA?
> (thereby severing its connection to the shared disk)?
>
> Or is failover only triggered if the heartbeat is not maintained?
>
> thanks a lot,
> alec
> --
>

Relevant Pages

  • RE: ERR VSS: Got Component: Cluster Database
    ... Ernie ... > Have you checked all the resources to make sure they list both nodes as ... > Windows NT/2000/2003 Cluster Technologies ... I'm running SQL Server clustered on a two node ...
    (microsoft.public.windows.server.clustering)
  • Re: 3 quick Qurestions about SQL
    ... own name, IP and resources or just a good idea, I am planning on doing it, ... last SQL cluster did not have one But I didn't build it. ... but configuring MSTDC on a cluster is a good idea. ... Present the LUNs to the new node by changing the SAN storage group. ...
    (microsoft.public.sqlserver.clustering)
  • RE: ERR VSS: Got Component: Cluster Database
    ... Windows NT/2000/2003 Cluster Technologies ... >> Have you checked all the resources to make sure they list both nodes as ... I'm running SQL Server clustered on a two ... >>> resources on it whenever I do a windows update. ...
    (microsoft.public.windows.server.clustering)
  • Re: 3 quick Qurestions about SQL
    ... own name, IP and resources or just a good idea, I am planning on doing it, My ... last SQL cluster did not have one But I didn't build it. ... but configuring MSTDC on a cluster is a good idea. ... Present the LUNs to the new node by changing the SAN storage group. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... G:\Microsoft SQL Server\MSSQL.1 ... CHNSQL04 Cluster Group ... Drives: H and F ... Group, the MS DTC Group, and each of the SQL Server Instance Groups running ...
    (microsoft.public.sqlserver.clustering)