February 2, 2016 at 3:44 pm
We have SQL Server 2005 SP1 with 32 bit
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Planning to upgrade to SQL 2008r2.
Do we need to select processor Type X86 under the options from SQL installation center?
By default it is showing X64. Is it ok to leave that?
February 2, 2016 at 8:10 pm
ramana3327 (2/2/2016)
We have SQL Server 2005 SP1 with 32 bitMicrosoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Planning to upgrade to SQL 2008r2.
Do we need to select processor Type X86 under the options from SQL installation center?
By default it is showing X64. Is it ok to leave that?
What's the architecture of your operating system? That's the version of SQL Server you want to install.
A related question is about your upgrade. Are you planning on doing this in place or spinning up new hardware and then migrating your databases to the new server?
February 2, 2016 at 11:10 pm
In place up gradation. 64bit operating system
February 3, 2016 at 1:55 am
You can't do an in-place from 32-bit to 64-bit iirc. You'll need to either install a new instance and move the DBs across or uninstall the old and install the new one.
Why upgrading to2008 R2? It's out of support and ~6 years old. We're expecting SQL 2016 probably within 6 months. Why not upgrade to 2014 or at least 2012?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 3, 2016 at 6:02 am
GilaMonster (2/3/2016)
You can't do an in-place from 32-bit to 64-bit iirc. You'll need to either install a new instance and move the DBs across or uninstall the old and install the new one.Why upgrading to2008 R2? It's out of support and ~6 years old. We're expecting SQL 2016 probably within 6 months. Why not upgrade to 2014 or at least 2012?
+1 to that. Also, you have a cluster, you can't upgrade the operating system. https://support.microsoft.com/en-us/kb/935197. If it were me, I'd want new hardware anyway. The migration will be safer.
February 3, 2016 at 8:39 am
ramana3327 (2/2/2016)
We have SQL Server 2005 SP1 with 32 bitMicrosoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Planning to upgrade to SQL 2008r2.
Do we need to select processor Type X86 under the options from SQL installation center?
By default it is showing X64. Is it ok to leave that?
this is detected by the installer, be aware that you cannot upgrade from 32 bit to 64 bit.
Ed Wagner (2/3/2016)
Also, you have a cluster, you can't upgrade the operating system. https://support.microsoft.com/en-us/kb/935197. If it were me, I'd want new hardware anyway. The migration will be safer.
Cant see any mention of a cluster in the original post
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2016 at 10:02 am
This is not cluster.
Is it ok to change to X86 in the installation media and run the upgrade? It should work right
February 3, 2016 at 10:42 am
Perry Whittle (2/3/2016)
ramana3327 (2/2/2016)
We have SQL Server 2005 SP1 with 32 bitMicrosoft SQL Server 2005 - 9.00.5000.00 (Intel X86)
Planning to upgrade to SQL 2008r2.
Do we need to select processor Type X86 under the options from SQL installation center?
By default it is showing X64. Is it ok to leave that?
this is detected by the installer, be aware that you cannot upgrade from 32 bit to 64 bit.
Ed Wagner (2/3/2016)
Also, you have a cluster, you can't upgrade the operating system. https://support.microsoft.com/en-us/kb/935197. If it were me, I'd want new hardware anyway. The migration will be safer.Cant see any mention of a cluster in the original post
Son-of!@#. I edited out the word "if" and I feel like an idiot. I'll take this as a reminder to proofread, no matter how simple. Thanks for pointing it out.
February 4, 2016 at 5:08 am
ramana3327 (2/3/2016)
This is not cluster.Is it ok to change to X86 in the installation media and run the upgrade? It should work right
just again to reiterate, No it won't!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 4, 2016 at 12:37 pm
It worked fine but after the upgradation it is showing 64bit.
Thanks everyone
February 4, 2016 at 4:03 pm
ramana3327 (2/4/2016)
It worked fine but after the upgradation it is showing 64bit.
the architecture is detected by the installer, anything else is a futile exercise
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply