Hi I've discovered that a sql 2005 cluster we have has got one node patched to sp2 and the other is not patched. Also the unpatched version seems to be missing management tools as I can't create maintenance plans. Is it safe to fail over to the patched node and then patch the unpatched node? If not then how should I best proceed? thanks in advance for your help Martin
According to link below failover to other node and add the SP is best way, http://sqlserver-qa.net/blogs/tools/archive/2008/03/27/sql-server-clustering-get-pre-installation-information-and-choose-the-best-practices-for-your-environment.aspx Thanks Sat