August 2, 2010 at 11:13 am
I am getting prepared for an installation of sp3 on sql 2005 clustered server again. I always get a little nervous just before doing this especially on a clustered box.
Is it required to reboot the whole server after sp3 is applied on active node or just SQL? I usually don't stop any services. Should I? If so what you do to take down the sql services is a bit different that a standalone server. With clustered server, you have to take sql services offline to bring down the sql services.
What I have been doing in the past is to apply sp to active node, rebooting the active node server that forces switch to node 2 then I apply sp on that node. Then I reboot that node server to force failover to node 1 again.
BOL and tools are on both nodes and so is integrated services.
August 2, 2010 at 1:11 pm
A reboot is required after applying SP3. You need not stop any SQL related services before applying the Sp3.
You need to install the SP3 on the passive node in order to install Client tools.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 2, 2010 at 1:17 pm
Thanks alot for the info. I have been doing it correctly from the beginning. Since we don't do these things all the time, I get a little nervous. I don't want to run into any issues.
Thanks again.
Patti
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply