May 27, 2010 at 12:50 pm
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
May 27, 2010 at 12:54 pm
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.
May 27, 2010 at 12:57 pm
You should be able to run x32 version of SQL on 64 bit OS. You cannot run x64 version of SQL on 32bit OS.
May 27, 2010 at 1:04 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply