SQL 2005 SP 4 Upgrade on Win 2k3 in Veritas Cluster

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  February 9, 2012 at 4:48 am

  #250453

  I got a query from friend.

  He wants to Apply SP4 of SQL 2005 server on Windows 2003 server in VERITAS Cluster Environment ( Active – Active).

  Does Anybody has any specific instruction on this.

• Perry Whittle

  SSC Guru

  Points: 233821

  More actions

  February 9, 2012 at 1:04 pm

  #1445254

  Yes, fail all instances to one node.

  Go into VCS cluster console and for all cluster groups place them into Freeze-Temporary

  Once this is done reboot all passive nodes and then run the SP4 exe with the /Passive switch.

  Once all passive nodes have been updated failover the instances to the upgraded node.

  Now run the SP4 exe with the /Passive switch on the final node.

  Unfreeze all cluster groups.

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉