Post reply

Upgrading 32bit SQL 2005 Two-node Cluster to 64bit SQL 2008 Cluster

  • February 12, 2009 at 8:44 am

    #155269

    Hi SQL guys out there? I need to upgrade a 32bit SQL 2005 Two-node Cluster to a 64bit SQL 2008 Cluster. The OS will have to be upgraded too. Anybody out there know the correct upgrade procedure? Any whitepapers on this? A sort of how to? 🙂

    Thanks a million

    Macphil

  • February 12, 2009 at 1:00 pm

    #943129

    I do not know about upgrading windows. But as far as SQL Server goes, i believe you will not be able to upgrade a 32 bit sql 2005 to 64 bit sql 2008. You will have to uninstall the existing sql 2005 and reinstall the new 2008.

  • February 12, 2009 at 1:10 pm

    #943135

    Hi macphil

    This is a huge undertaking to upgrade both the version and the architecture (32 -> 64) at the same time as well as windows.

    If I were you and I could propose a plan, I would like to do the upgrade one part at a time to properly catch most of the exceptions and not to worry if they are pertaining to the 32 -> 64 bits upgrade or from a deprecated or change behavior from 2005 -> 2008 or from a modified windows behavior.

    Although changing windows seems less an issue than the two others one, I do believe that you should upgrade and test them independently.

    my2cents

  • February 12, 2009 at 1:17 pm

    #943143

    Humm sqlsatyam, I have never done an upgrade from 32 to 64 bits but judging from this article I do think it might be feasible:

    http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693_mem1,00.html

    One step at a time and I believe it could be done.

  • February 12, 2009 at 2:31 pm

    #943207

    I am pretty sure that upgrading a 32bit SQL 2000 to 64bit SQL 2005 is not possible. I have tried that once and i failed. I am assuming it is the same for 2005 to 2008 also...I am also not sure if upgrading from a 32 bit SQL 2005 to a 64 bit SQL 2005 is possible either.

  • February 12, 2009 at 2:38 pm

    #943213

    first question is does the hardware support 64 bit platforms?

    if yes then you would need to move all objects (databases, logins, etc) out of the cluster to a temporary sql server. Install the NOS and configure the cluster then install sql server. Finally migrate all objects back in. Realistically this is a hell of a lot of work

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • February 13, 2009 at 6:45 am

    #943515

    sqlsatyam, through scripting (the last resort option) I don't see why it couldn't

  • February 16, 2009 at 12:48 am

    #944347

    Thanks For all your help SQLites!!

  • February 17, 2009 at 1:50 pm

    #945468

    I did a 2-step process: Upgraded a 32-bit SQL 2000 cluster to SQL 2005 (had the 64-bit cluster installed and ready in case there were problems), then later moved the database to the 64-bit server. No problems, however we did need to have a second cluster available.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply