SQL Server 2005 32 bit vs 64 bit

Question

SQL Server 2005 32 bit vs 64 bit

HBK_4700

SSCrazy Eights

Points: 8932
More actions
May 27, 2010 at 12:50 pm

#140524

What is the difference between sql server 2005 32 bit and 64 bit. Do we need to have OS 64 bit to install sql 64 bit. Can we restore 32 bit version database in 64 bit version and 64 bit db in 32 bit?? Many thanks

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

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

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 1

laddu4700 (5/27/2010)
What is the difference between sql server 2005 32 bit and 64 bit. Do we need to have OS 64 bit to install sql 64 bit. Can we restore 32 bit version database in 64 bit version and 64 bit db in 32 bit?? Many thanks

Yes, you need 64 bit hardware with 64 bit OS to install 64 bit SQL.

Yes, you can restore a 32 bit version database to a 64 bit version system and a 64 bit version database to 32 bit.

Steve Cullen SSCertifiable Points: 5598 More actions · Answer 2

You should be able to run x32 version of SQL on 64 bit OS. You cannot run x64 version of SQL on 32bit OS.

Converting oxygen into carbon dioxide, since 1955.

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 3

Steve Cullen (5/27/2010)
You should be able to run x32 version of SQL on 64 bit OS. You cannot run x64 version of SQL on 32bit OS.

True, but to clarify, I can backup a database under x64 SQL Server 2005 and restore it to an x86 (32 bit) SQL Server 2005 server.