No, seriously. What is the clustering system in use? 'cos the Symantec / Veritas cluster you'll need to go through the process on all servers individually, whereas (as I understand it), you may be able to only do one of the active servers in a MSCS environment. (You'll probably have to shut down the other active node temporarily...)I have a clustering bloke here, and I'm trying to learn from him - when he's not too busy!
answered Dec 15, 2010 at 12:09 AM
First of all, cluster administration is a tricky business - especially when running on anything before Windows 2008 and SQL 2008. Before doing anything: read, understand, practice, prepare (incl. backup), then implement.
I agree with Thomas that you have to be careful depending upon environment. As I understand it, you install the SP on the active node, and it takes care of the other nodes. I think you need to fail service over to one of the nodes after reading the information below.
As found in the SP3 Release Notes from Microsoft:
Installing SQL Server 2005 SP3 on a Failover Cluster Instance Note the following information before you install SP3 on a failover cluster instance:
For more information about failover cluster installation, see the ["Installing the Service Pack (Hotfix)"] topic in the SQL Server 2005 SP3 Setup documentation. The Setup documentation is available from the SQL Server 2005 SP3 Readme Files download page.: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=851C39EE-6F9D-47D9-8ECC-44AC1E9DC182&displaylang=en
answered Dec 15, 2010 at 12:13 AM