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.