Have 5 SQL 2005 to 2008 R2 clustered instances. I've setup a new cluster to prepare to use the cluster migration wizard. As I understand it you have to install SQL before running the cluster migration wizard. My question as it relates to this is, what type of install do I do?
Should I just setup a new standalone SQL install, do the migration wizard, and then uninstall the standalone instance? Or do I need to do a clustered install?
The MS pages as it relates to SQL, don't go into these specifics: http://technet.microsoft.com/en-us/library/ff182337(v=ws.10).aspx
Thanks!
Best Answer
I wouldn't trust the migration wizard to copy everything over correctly for SQL Server. I can see this leaving you with a broken SQL Server instance. What I would recommend doing would be the following...
If rollback is needed because something isn't working you detach the databases from the new instance, move the LUNs back to the old cluster, then roll back the SAN snapshot and reattach the databases to the old version of SQL Server.