How to apply service packs on a sql cluster

Question

How to apply service packs on a sql cluster

Oracle_91

SSChampion

Points: 14548
More actions
July 7, 2010 at 4:07 am

#141853

Hi,
What are the steps involved if we want to apply a service pack on a two node clustter?
How different it is from normal service pack installation
Thanks,

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

It's not very different. The SP is applied automatically to all nodes, moving the instances accordingly. You will probably have to fail over the instances to the preferred owners at the end of the setup.

Service packs are usually associated with a KB article that describes the installation process in depth.

Hope this helps

Gianluca

-- Gianluca Sartori

sql_lock SSCrazy Eights Points: 9373 More actions · Answer 2

As previous post say the KB's tell you step by step what to do. The SP's are cluster aware.

Below are the steps from 2005 SP3 readme.
Note the following information before you install SP3 on a failover cluster instance:
Do not stop the cluster service before you run the SP3 Setup program, or while the installation program is running.
Do not end any running processes before you run the SP3 Setup program.
Do not take the SQL Server service offline before you run the SP3 Setup program. The SP3 Setup program will stop and start the SQL Server service.
Run the SP3 Setup program on the primary node of the failover cluster instance.
The SP3 Setup program might require you to restart the failover cluster nodes. This restart replaces the files that were in use during Setup.
Rolling upgrade is not supported for SP3.