June 27, 2011 at 7:00 pm
Guys and Girls. I have a SQL Server 2008 cluster. I want to update it to 2008 SP2. Is it just a matter of updating each instance separately? Would love to read some articles on what is required. My thinking is upgrade the server not currently in use, fail the other server over and then upgrade the other server. Should be no issues with the database as its all 2008. Would love some confirmation on this.
Brian
June 28, 2011 at 1:26 am
You appear to have stumbled on best practice.
1. Apply SP to passive node
2. Failover cluster
3. Apply SP to passive node
June 28, 2011 at 2:40 am
Agreed
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
June 29, 2011 at 5:57 am
I have done this several times in that order. Make sure you make backups of master, model, msdb and an app dbs before you apply SP2 as a just in case.
June 29, 2011 at 6:32 am
Also, you shouldnt attempt to fail back until you applied the update to the second node as the binaries and databases will be of differing versions.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply