Everytime I bounce my primary node in my 2008 cluster, the cluster fails over to the secondary node. How can I stop this? Also since it is SQL Server 2008 Cluster on top of MSCS 2008, do I need to set the policy on both levels or will the MSCS 2008 policy take care of it.
Basically I do not want the cluster to failover when a patch is installed and reboot is required.
Also, when the cluster does failover, how do I get it to failback? Is this just on the MSCS side or the SQL Server side as well? Thank you for your help.