First off thanks for reading and lending a hand.

His my situation. We have a 2 node cluster both 2003 64bit OS but one of the nodes is SQL 2005 Ent edition 32 bit and the other node is SQL 2005 Ent edition 64bit edition.

My goal is to upgrade the 32 bit edition to be a 64 bit edition and I was wondering what would be the best way to go about this. My initial thoughts were to backup all the databases (system), detach the user databases. Uninstall sql server on the 32 bit node then do a reinstall of sql 2005 64 bit on that node. Reattach user database and add users and jobs. Apply sql 2005 sp2.

Has anyone done an upgrade like this or have a better way? I’m not sure my way would be the best way or if it would even work.


Thanks for your time.