3

Today I was told that SQL Server 2008 is supposed to be run on Server 2008 R2 (64 bit). Is this true? And if so, can anyone explain why?

Our development instances are running on 32-bit systems. I don't have any issue with migrating to 64-bit, but are there specific reasons why this is a preferred method?

2
  • 2
    Do you have > 4Gb of RAM? If so, then there's no good reason why you should be using x86 (to flip the question). Aug 16, 2010 at 21:29
  • 2
    I think "supposed to be" really translates into "this is definitely Microsoft's direction". Things are finally headed to 64-bit. No reason to hold back.
    – squillman
    Aug 16, 2010 at 22:10

2 Answers 2

4

With x64 you get access to more RAM and CPU power than with an x86 OS and SQL Server version. You can use Server 2008 x64 as well.

4

Whoever told you that is mistaken. SQL Server 2008 was released before Server 2008 R2, so how could it be intended to only run on Server 2008 R2?

I think the issue that is being confused is that Microsoft strongly recommends the x64 version of SQL Server. They are pushing everyone to their x64 platform, so if you choose to install the x86 version of software, you may find yourself without an upgrade path in the future. This has nothing to do with Windows Server 2008 R2 other than the fact that it happens to only come in an x64 flavor.

4
  • Well... the upgrade path would be to move to x64. The databases are completely interchangable between x86 and x64 platforms (not sure about IA64) Aug 16, 2010 at 22:54
  • @Farseeker - Right, if you wish to upgrade the version of SQL in-place (not that I recommend that) and you are on an x86 OS, you are out of luck.
    – MDMarra
    Aug 16, 2010 at 23:28
  • well yeah that's true. And you can't actually do an in-place upgrade from x86 to x64 so I guess in the strict sense of the word upgrade you're correct. Aug 16, 2010 at 23:57
  • @Farseeker - Not that I would ever recommend it, but I've been consulting for some smaller shops on the side lately where resources are limited and some people actually have to do that kind of thing. Gross, I know.
    – MDMarra
    Aug 17, 2010 at 0:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .