Will it be possible to do an in-place upgrade from SQL 2000 Server Enterprise SP4 32 bit running on top of 64 bit Windows 2003 Enterprise , clustered, to SQL 2005 Enterprise 64 bit
The 32 bit SQL 2000 to 64 bit SQL 2005 in place upgrade seems questionable to me...
Anybody tried anything like this
Upgrading 32 bit SQL 2000 SP4 Ent running on 64 bit Windows 2003 Enterprise to SQL2005 64 bit in place
Shailendra18
On x64 machines, 32-bit SQL Server 2000 and SQL Server 2005 can be installed successfully side by side. But there is not 64-bit SQL Server 2000 for x64 machines.
It is not supported to upgrade 32-bit SQL Server 2000 to 64-bit SQL Server 2005 directly, which is by design. This is also true for cluster scenario.
The following can be a workaround on x64 machines or clusters.
1. Uninstall 32-bit SQL Server 2000 and saved 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 data from 32-bit SQL Server 2000 to 64-bit SQL Server 2005.
3. Uninstall 32-bit SQL Server 2000.
Please back up your database before any major operation.