I was wondering if anyone has the exact step by step procedure of what I will need to do when updating the 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.
What I know from researching myself is I should be able to install the SP3 on the live active node and when that is complete I can then just install the tools/components on the Passive node and this should do it. But what I am not sure about is weather I need to install the SP3 on the active node and then fail over to the passive node and install the SP update when the passive node is active or not. Here is where I am confused.