I need to upgrade my current instance of sql 2005 to sql 2008r2. Here is my current setup:
We have two windows 2003 servers in a clustered environment. Each node has sql 2005 installed on it and is participating in the fail over cluster.
I have two new servers with Windows 2003 server installed that i want to use to replace the existing ones. I would like to add the two new servers as nodes in the current cluster using the sql 2008r2 installation disk. Then, over time, i will
evict the old servers.
Is this possible? Can I add a sql 2008r2 node to a sql 2005 cluster? If not, what is the best way to do this?
I am not sure if your scenario is supported, but there is one that would be: Rolling upgrade... What you would have to do is install SQL 2005 on those new boxes and then upgrade those inplace to 2008R2. The thing with this is though that after your first
failover to one of the upgraded instances your old 2005 installations instantly become useless as they can no longer read the database files...