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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-27 : 07:58:48
|
| Kambiz writes "Hi,We are trying to migrate our sql server 2000 standard (SP 4 - 32 bits) databases,it is currently on a windows 2003 Standard (32 bits) server.The new sever is running a windows 2003 Enterprise R2 (64 bits) and I have installed sql server 2000 standard (SP 4 - 32 bits) on it - same as the last server-My question is if there is any issues that I have to be aware of , i have googled, but couldn't find any help regarding this subject.Thanks In AdvancedRegards,Kambiz" |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-10-27 : 09:52:16
|
| Biggest problem you will likely run into is getting the logins to map to the users. This can be easily fixed with the sp_change_users_login procedure. Look it up in BOL for the parameters. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-28 : 03:10:01
|
| Am I missing something? Why would you move SQL from a 32bit platform to a 64bit platform and knobble it by keeping a 32bit SQL version?Kristen |
|
|
|
|
|
|
Restoring sql server 2000