Help on upgrade 32bit SS 2005 to SS 2008 R2 on a 64 bit machine

Question

Help on upgrade 32bit SS 2005 to SS 2008 R2 on a 64 bit machine

mattech06

SSCrazy

Points: 2484
More actions
December 6, 2014 at 3:19 am

#397742

Hi,
I'm looking to upgrade 32bit SS 2005 to SS 2008 R2 on a 64 bit machine.
Should I try and install the 32 bit or 64 bit SS 2008 R2?
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

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

mattech06 SSCrazy Points: 2484 More actions · Answer 1

Seems like 64 bit is the way to go

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2c463d34-599c-4da4-a1ca-1b5425af1aae/upgrade-using-32-or-64-version-of-ss-2008-r2?forum=sqlsetupandupgrade

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 2

Quick thought, on a 32 bit version of SQL Server there are severe restrictions not applicable to the 64bit version, even more true with 2012/2014 where the AWE support has been dropped. No question, go with the 64bit if possible.

😎

mattech06 SSCrazy Points: 2484 More actions · Answer 3

I forgot to mention in my question about whether to install 32 or 64 bit 2008 r2 that I was talking about the EXPRESS edition (with adv services).

So it turns out that my above posting is wrong.

I installed the 32 bit 2008 r2 express with adv services onto my 64 bit machine and upgraded ss 2005 express with adv services ok.

thanks,