We are currently running a working SQL Server 2005 Failover cluster, with 2 nodes. We are now in the process of replacing the servers in that cluster with 2 new servers running SQL Server 2008, my question, should I add the new servers to the current cluster and then retire the old servers or create a new cluster and then copy the databases to the new servers?
migrated from stackoverflow.com Jan 2 '12 at 20:24
It would be cleaner and potentially more reliable to build your new SQL 2008 cluster first on new hardware. Do a test migration by restoring your databases from backups into your new cluster.