upgrade SQL server 2008 to R2 2 node cluster

Question

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.

NODE1

SQL1 & SQL2 - running

                                                                                                                                                                               

NODE2

Steps:

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

Answer 1

Hello Murali,

The steps are correct, but please see the section “Best Practices Before Upgrading a SQL Server Failover Cluster” on the following link:

http://technet.microsoft.com/en-us/library/ms191295(v=sql.105).aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com