Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
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). –  Mark Henderson Aug 16 '10 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 '10 at 22:10

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer

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.

share|improve this answer
    
Well... the upgrade path would be to move to x64. The databases are completely interchangable between x86 and x64 platforms (not sure about IA64) –  Mark Henderson Aug 16 '10 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 '10 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. –  Mark Henderson Aug 16 '10 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 '10 at 0:20

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.