jayoub (3/24/2014)

---

I am working on migrating an SQL Cluster from Windows Server 2003 SQL 2005 to Windows Server 2008 SQL 2005 and I am considering doing the following:

Install Windows Server 2008 R2 on two new servers (DONE)

I would like to take these two servers off the network (disable the NIC)

Installing the Windows cluster and the two virtual instances on the new servers in Active/Active mode using the same names and IP addresses as the two old servers

Back up the system and production databases from the old servers onto external hard drive

Restoring all system and production database to the new servers

Take the old servers off line (disable the NIC or something)

Placing the two new servers on the network (enabling the NIC)

Testing

Rollback would be

Take the new servers off the network (disable NIC)

Putting the old servers back on the network (Enable the NIC)

The goal is not to have to change the application connections to the databases.

Please let me know what you think. Your help is appreciated.