sqlfriends (5/24/2013)
I will.Yes, I think what we have created two instances on node 1, one is for pro, th other is for qa, then we added the same two instances on node 2.
Does that mean when install the second node, He only added the node, he didn't install the two instances again with same names on node 2.
Also when applying service pack, do I need to run on both nodes even the passive one ?
This is a SQL server 2008 cluster.
Thanks
Yes, when installing a cluster failover instance you install the instance on the first node, then you add it to the second node.
And yes, you have to patch both nodes. Do the passive first, then fail over your instances then patch the new passive node (this is assuming sql 2008). I believe the patching process is different for 2005 (i.e, you might have to patch on the actual active instance). - Check that first though.