SQL 2005 Cluster Active / Passive SP2 to SP3 Procedure request

Question

SQL 2005 Cluster Active / Passive SP2 to SP3 Procedure request

jason.nodarse

Ten Centuries

Points: 1143
More actions
June 9, 2010 at 1:13 pm

#223577

I was wondering if anyone has the exact step by step procedure of what I will need to do when updating From SQL 2005 SP2 to SP3?
I have two Windows 2003 Enterprise 32 bit servers with SQL 2005 Enterprise SP2 installed on them and clustered as a Active / Passive setup.

Viewing 6 posts - 1 through 5 (of 5 total)

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

saleemkhanm SSC Enthusiast Points: 168 More actions · Answer 1

First apply SP on Passive node, once completed, failover active node to this passive node, now this will become active and other passive, then apply SP on Passive node, once completed, then failback to this node, or leave there.

jason.nodarse Ten Centuries Points: 1143 More actions · Answer 2

Thanks for the response but all the links I find tell me to first install the SP3 on the Active node and the SP3 software is Cluster aware so it will detect that there is a cluster in place and it will automatically update the passive node but it will not update the passive nodes tools so I will have to install the tools on the passive node seperate. I like your way better so if you can please provide me with a link or some info that can backup your recommendations that would be great.

Once again thank you.

CavyPrincess Hall of Fame Points: 3336 More actions · Answer 3

For SQL Server 2005, you just need to apply the SP to the primary node. I've always applied it to the same node where SQL Server was originally installed. After you install it in the primary, you should do a failover and confirm the SP was applied. I believe you may have to run SP on the failover node for the components that are not cluster-aware, but my installation doesn't have these (like SSRS for example).

From what I've read, this is different in SQL Server 2008 (and you are posting in a 2008 forum), but I haven't stood-up a 2008 cluster yet.

HTH,

Cindy

jason.nodarse Ten Centuries Points: 1143 More actions · Answer 4

Thank you Cindy........I believe you are on the right track. All my research has pointed me to what you have explained.

Thanks again for the Info.

Perry Whittle SSC Guru Points: 234013 More actions · Answer 5

Jason, to avoid confusing people (as you have here) please post in the correct forum in future. Saleems advice to you below is correct and valid for SQL Server 2008 clustered installations.

saleemkhanm (6/9/2010)
First apply SP on Passive node, once completed, failover active node to this passive node, now this will become active and other passive, then apply SP on Passive node, once completed, then failback to this node, or leave there.

For SQL Server 2005, you must apply the SP from the active node. In an active\active cluster you would fail all instances to the one node. As you have an active\passive cluster just launch the SP from the active node, it doesnt have to be the node the instance was originally installed on!

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

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