August 25, 2005 at 9:31 am
What is the preferred method for installing SQL Server SP4 on an active/passive cluster - the operating system is windows server 2003
August 25, 2005 at 10:18 am
Be sure you are not using AWE, some issues with SP4 there and I'd scan Google and be sure there are no other issues. Might want to test if possible on another system.
August 25, 2005 at 1:19 pm
I have already done all of our stand alone servers including one that is AWE enabled, the hotfix after SP4 install works fine for AWE. Unfortunately, the only cluster in the company is a production 24/7 ecommerce system, I can't get the money for a test or qa cluster. The main question is: Our network admin wants me to logon to the nodes directly and update them, then reestablish the cluster if it doesn't work. He also wants me to pull the network cable as a way of shutting off web traffic which doesn't leave me any other options......I want to logon to the virtual server, install SP4, failover to the other node, install SP4, fail back to the primary. I'm looking for opinions on what's the preferred way to do it.
August 26, 2005 at 8:05 am
If you log on to the virtual server and install SP4, it will be installed onto both cluster nodes...you don't have it install it on each node.
August 26, 2005 at 11:29 am
I just ran into this KB article the other day ...
http://support.microsoft.com/default.aspx?scid=kb;en-us;174799
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 26, 2005 at 11:53 am
This KB article applies to Windows service packs. However, you only need to apply SQL Server service packs on one cluster node.
August 30, 2005 at 9:41 am
Thank you, this confirms what I believed to be true.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply