I'd like to clarify that SQL Server 2000 can be ran on the 64bit edition of Windows Server using SP4. We'd like to do this as an interim step for moving to 64bit SQL 2005.
Thanks for any comments.
Darren
There is a 64 bit version of SQL Server 2000 that runs on Itanium machines and it is directly upgradable to SQL Server 2005 64 bit. That's your "best" path. There is *not* a corresponding version of SQL Server 2000 that runs on x64 chips. I can't remember offhand if the 32 bit version of SQL Server 2000 is supported in the WoW on x64. If you want to go that route, post another note and I'll track down the answer.
Paul
Yes. 32-bit SQL Server 2000 and its SP4 can be installed on x64 machines. There is neither 64-bit SQL Server 2000 nor its SP4 for x64 machines. But there is 64-bit SQL Server 2000 for IA64 machines. So is its SP4.
32-it SQL Server 2000 on x64 machines can be upgraded to 32-bit SQL Server 2005 on x64 machines directly. However, it is not supported to upgrade 32-bit SQL Server 2000 on x64 machines to 64-bit SQL Server 2005 on x64 machines directly.
The following steps may work for your scenario.
1. Uninstall 32-bit SQL Server 2000 and save its database.
2. Install 64-bit SQL Server 2005 and attached the saved database.
Or
1. Install 64-bit SQL Server 2005 side by side with 32-bit SQL Server 2000, which is supported.
2. Transfer all data from 32-bit SQL Server 2000 to 64-bit SQL Server 2005.
3. Uninstall 32-bit SQL Server 2000.
Anyway, before you do any major change, please back up your database first.
