I have been tasked with moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.
The active/active 2008 SQL cluster consists of two nodes that are running Windows Server 2008 Enterprise edition. These nodes connect to an EMC SAN which has been operating flawlessly for about one year.
The active/passive 2005 SQL Cluster consists of two nodes running Windows Server 2003 Enterprise Edition. It is connected to an IBM EXP400 SAN which has been in production for about three years.
My question is what would be the best way to acheive this? My plan as of right now is to stop SQL Server 2005 to kill all connections and then restart SQL. Then I would detach the database and copy it to an external hard drive. I would then insert the SQL Server 2008 disk into the drive of the 2008 Server and select create a new SQL server fail over cluster. Once that is set up I would then reattach the databases to the new 2008 active/passive cluster.
I am sure I am missing something here as this sounds way to easy so I would love it if someone could verify my steps here. Although I have been working with clusters for a number of years, I have never had to run more than one cluster per server. I just want to make sure I have a full understanding before I go ahead with this.
July 15, 2010 3:33 PM
July 15, 2010 5:51 PM