Results 1 to 7 of 7

Thread: sql 2005 32 bit to sql 2005 64 bit Cluster upgrade questions.

  1. #1
    Join Date
    Aug 2004
    Posts
    188

    sql 2005 32 bit to sql 2005 64 bit Cluster upgrade questions.

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You can try in place upgrade. Or install 64-bit instance first, move all dbs from 32-bit instance, then drop 32-bit ones. If like to do what you planed, you should backup all dbs (system's and user's).

  3. #3
    Join Date
    Aug 2004
    Posts
    188
    Thanks!

    So it's possible to do an inplace upgrade of sql 2005 32 bit to sql 2005 64 bit without any issues?

  4. #4
    Join Date
    Aug 2004
    Posts
    188
    We do replication with over 150 nodes so we want to keep the same instance name going from 32bit --> 64 bit. If we dont it will be a nightmare.

  5. #5
    Join Date
    Sep 2002
    Posts
    5,938
    Build a test machine and test in place upgrade. You'll need reconfigure replications otherwise.

  6. #6
    Join Date
    Aug 2004
    Posts
    188
    I'm starting that process now. I think I will have to build a virtual cluster to mimic the prod servers and do the upgrade there.

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    You can just test it on single machine, makes no difference from cluster.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •