Failover issues

#11

Quote:

1. If the node is running the 1st instance that was configured on the box
and this goes down / away the Instances never fail to the other node. We have
to restart cluster services to bring it online.

What does 'this' refer to in 'and this goes down/away'? If it's a resource
that does down and does not cause the group to fail over, the most obvious
thing to check is whether it is configured not to affect the group on its
Adavanced tab.

Linchi

"Simon B" wrote:

Quote:

We have built a SQL Cluster and all goes well with the failover of the
Instances when either node is gracefully shutdown, ie the instances failover
in roughly 10 seconds to the other node.

The issue we are having is when a non grace full shutdown occurs Ie we are
diconnecting the NIC's Heartbeat and LAN the results are

1. If the node is running the 1st instance that was configured on the box
and this goes down / away the Instances never fail to the other node. We have
to restart cluster services to bring it online.

2. If we fail the other node which has some other instances running on it
after about 90-120 seconds they come back online.

Where are we going wrong ? Can anyone provide any ideas ?

Hardware is HP Blade centre connecting to Iscsi Netapp.

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

Failover issues

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

RE: Failover issues - 09-11-2008 , 08:22 PM