Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2010-05-27 : 14:49:32
|
| 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 |
|
|
Miki
Starting Member
5 Posts |
Posted - 2010-05-27 : 15:19:23
|
"it is different performancewise and of course 64 bit is faster. But, it only runs 64 bit applications only. Yes, you can restore 32 bit database to 64 by using restore in sql"quote:
Originally posted by laddu
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
|
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-27 : 15:34:15
|
| The database file formats are identical, as are the backup formats.You need a 64-bit OS to install 64-bit SQL. Unless you're talking about Itanium, a 64-bit server with 64-bit OS will run 32-bit software just fine. (My desktop runs a 64-bit OS and a mix of 64 and 32 bit software)The difference between 64-bit and 32-bit is not speed. 64-bit is not necessarily faster. The main difference is that a 32-bit app can never address more than 4 GB of memory, while a 64-bit app can address memory up to 16 exabytes or so.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
SQL Server 2005 32 bit vs 64 bit