February 12, 2009 at 8:44 am
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
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
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
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
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
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
sqlsatyam, through scripting (the last resort option) I don't see why it couldn't
February 16, 2009 at 12:48 am
Thanks For all your help SQLites!!
February 17, 2009 at 1:50 pm
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