I am trying to upgrade a 2-node Windows 2008 Cluster with SQL Server 2008 
installed to Windows 2008 R2. 

I have followed the Microsoft practice of evicting one of the nodes from the 
cluster, removing SQL Server, upgrading the OS to R2 and creating a new 
cluster which all work fine.

My issue is that I need to migrate the SQL Server 2008 instance from the old 
cluster to the new Windows 2008 R2 cluster but can't see how to do it.

I have tried using the cluster migration wizard but this does not allow me 
to install SQL 2008 onto the R2 node. I have tried installing an instance of 
SQL 2008 onto the upgraded node (making a SQL 2008 clustered node) but the 
migration wizard doesn't copy the database details across and so the resource 
won't come on-line.


The Microsoft Cluster upgrade document Migration Paths for Migrating to a 
Failover Cluster Running Windows Server 2008 R2) states that I need to use 
the upgrade functionality built into the SQL Server Installation Wizard but I 
can't see how to do this.

Can anyone help here?  I have the same issue.  I have a 2 node Windows 2008 
cluster running SQL 2008.  I want to upgrade the OS to Server 2008 R2.  How 
do I get SQL 2008 onto the new R2 node?

"SimonM" wrote:

> I am trying to upgrade a 2-node Windows 2008 Cluster with SQL Server 2008 
> installed to Windows 2008 R2. 
> 
> I have followed the Microsoft practice of evicting one of the nodes from the 
> cluster, removing SQL Server, upgrading the OS to R2 and creating a new 
> cluster which all work fine.
> 
> My issue is that I need to migrate the SQL Server 2008 instance from the old 
> cluster to the new Windows 2008 R2 cluster but can't see how to do it.
> 
> I have tried using the cluster migration wizard but this does not allow me 
> to install SQL 2008 onto the R2 node. I have tried installing an instance of 
> SQL 2008 onto the upgraded node (making a SQL 2008 clustered node) but the 
> migration wizard doesn't copy the database details across and so the resource 
> won't come on-line.
> 
> 
> The Microsoft Cluster upgrade document Migration Paths for Migrating to a 
> Failover Cluster Running Windows Server 2008 R2) states that I need to use 
> the upgrade functionality built into the SQL Server Installation Wizard but I 
> can't see how to do this.