Re: Shared disk does not failover if public nic goes down

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Gerald Aigenbauer (ga_at_ntc.at)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 16:53:42 +0100

hi andrew!

i think there is a installation and configuration problem.

each cluster group need to have an ip address to be contacted from outside.
if you use sql in a cluster, all harddisks used for one sql instance need to
be in the same cluster group
you are not able to define dependencies between cluster groups.

so move drive d and e to the group, where the sql instance was installed
into and the ip address, which you use for connecting the clients to the sql
cluster resides.

gerald aigenbauer.

"R. Andrew Johnson" <pens18aj@yahoo.com> schrieb im Newsbeitrag
news:uNSh9TuAFHA.3616@TK2MSFTNGP11.phx.gbl...
> We have a 2 node 2003 cluster setup.
>
> We have 2 public network cards teamed with Broadcom software on both
> servers. Segment-172.18.1.*
> We have 1 Private Network card in each server seeing each other with a hub
> 10.0.0.*
>
> We have 2 shared disk groups from the SAN disk we presented to both
> servers.
>
> Cluster Group = Cluster IP address, Cluster Name, Q Drive/Quorum drive
> Group 0 =Drive D on both servers - For SQL 2000 LOGS
> Group 1 =Drive E on both servers - For SQL 2000 Database
>
> If we do a test were we pull both public network cables on Node A the
> Cluster group with the cluster IP , Cluster Name and Quorum disk failover
> to Node B. The 2 shared disk groups 0 and 1 do not fail over so they stay
> on Node A. We are thinking we need to define some dependence for this
> shared disks groups but what are the right dependence for this
> configuration? Do we have it depend on the Quorum disk or an IP address
> maybe?
>
> Any help would be great.
>
> Andrew

Relevant Pages

  • Re: custom path for data files
    ... to the cluster group, make SQL dependent on it, and use it for data or logs. ... I am about to install sql 2005 in a clustered scenario. ... drive you want to use for SQL Server from the Available Cluster Groups. ...
    (microsoft.public.sqlserver.clustering)
  • RE: Help setting up new SQL 2005 instance on an SQL cluster
    ... SQL 2005 Cluster which is already running SQL? ... however I am not sure of the steps that are needed prior to the install. ... I have tried to greate a new SQL cluster group however when I follow through ... If you have already create an IP address resource and a network name ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 Active/Passive Cluster - Move Cluster Group
    ... Moving the cluster group will not affect any running applications, including SQL. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2000 Active/Passive Cluster - Move Cluster Group
    ... "Geoff N. Hiten" wrote: ... Moving the cluster group will not affect any running applications, ... Principal SQL Infrastructure Consultant ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Issues creating a new failover cluster on the same server
    ... Both SQL instances are installed on the ... active node, CHSSQ04A. ... SQL server agent (CHSNextgen) ... We are not sharing drives for each cluster group and instance, ...
    (microsoft.public.sqlserver.clustering)