Jamie Wormald (8/3/2010)
If a resource fails on one of the sql instances what will make the server failover. The way I understand it only one server if live at any one time and this server is the one with access to the quorum drive. So if another server group failsover it will move to the failover server but the group with the quorom will stay where it is.
Depending off your settings for the cluster group members failover may occur.
Each resource group can failover by itself.
You can fail over one resource group indepentent from other resource groups.
Both nodes of your cluster can have resource groups active. Off course a resource group can only be active at one node at a time.
Both nodes must be up for failover to be able to use the mechanisme.
So a passive node, is a computer that mainly functions as a heating device until the cluster service or a cluster admin moves and activates a resouce group to it.
The resource group holding the quorum, can be active on any of the nodes.
I always put the quorums resouce group at the node where i want to install an instance, for the rest I don't care where it is active.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me