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 |
|
tgtcat6
Starting Member
2 Posts |
 Posted - 2007-08-30 : 14:18:01
|
| I'm sure this has been discussed in the forums before, but I'll ask anyways. I'm replacing our GP server next year to one that will run SQL2k5 64-bit. The current server is only capable of 32bit SQL. I know with some databases changing from x64 to x32 is a bad idea...will SQL Server support it?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-30 : 21:40:27
|
| You can move sql db between 32-bit and 64-bit without problem. |
 |
|
|
tgtcat6
Starting Member
2 Posts |
Posted - 2007-08-31 : 10:31:21
|
| Great, that makes things easier. Are there any settings that I should tweak to make things easier/better or should I just leave it along and let SQL Server take care of everything? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-31 : 15:22:56
|
| Just backup/restore or deatch/attac db, nothing to tweak. |
|
|
|
|
|
|
SQL 2k5 failover from 64bit to 32bit