SQL Server Performance

how to fix cluster with different patch levels on each node

Discussion in 'SQL Server 2005 Clustering' started by mwalter, Aug 27, 2008.

  1. mwalter New Member

    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
  2. techbabu303 New Member

    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
  3. mwalter New Member

    thanks for the link
    Martin

Share This Page