Monday, August 20, 2012 4:33 PM
I have 2 node windows 2008 cluster that has two sql instance running. SQL1 and SQL2 instance (SQL Server 2008 Ent).
I need to upgrade SQL1 instance to SQL Server 2008 R2 and leave the SQL2 to SQL Server 2008. what is best to do this.
After reading document this steps I will take.
SQL1 & SQL2 - running
run SQL Server 2008 R2 setup on node2
after upgrade is completed on NODE2, failover instance SQL2 to NODE2
run SQL Server 2008 R2 setup on node1 & reboot if required
test the upgrade
Let me know if this are correct steps, if not please provide your suggestions.
Thanks in advance
Monday, August 20, 2012 6:17 PMModerator
The steps are correct, but please see the section “Best Practices Before Upgrading a SQL Server Failover Cluster” on the following link:
Hope this helps.