SQL Server Performance Forum – Threads Archive

active/active passive cluster question

Hi, I had a 2 node active/active cluster and just added a third passive node. My question is since, I don’t have an actual instance on the third node, do I need to service pack it? The two active nodes are of course service packed. I’m assuming, I don’t need to install the service pack on the third node, correct? Thanks.

i guess u need to install the sp ,coz for the failover to happen u must have the same configuration as the failed node…Correct me if iam wrong… Regards
Suleman
Hyderabad

Service packs need to be installed once per instance: http://www.sql-server-performance.com/sqlserver2000_clustering_install_part3.asp

Thanks for the replies, but this still doesn’t answer my question. The third node is passive and thus has no instance. The two active nodes have already been service packed. Does anyone know if the passive node needs to have the service pack installed? If I run the service pack, it asks me for the virtual server names. Since the two active instances have the service pack this is confusing to me. Thanks.

hey the third node must have the service pack and the virtual server name shud be the name used to create the cluster…i think i answered it… Regards
Suleman
Hyderabad

You’re getting confused. It is not the node that needs the service pack, it is the SQL Server instance.

oh yeah i got it …i was indeed confused with that…lolz messed up again…thnx mulhall for the clarification Regards
Suleman
Hyderabad

]]>