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
This question came from our site for professional and enthusiast programmers.
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.