Not sure if this is possible, or what the steps are if it is. We have a server running Windows Server 2003 R2 64-bit as the OS, and SQL Standard Edition 2005 32-bit.
I have been tasked to upgrade the OS to Windows Server 2008 R2 64-bit AND the SQL to 2008 R2 64-bit.
Is it possible to do this without doing a format/reinstall? Can I upgrade the OS to 2008 and then upgrade SQL to 2008? Is there going to be a problem upgrading SQL to 64-bit?
We do have a database running on this server that has already been upgraded to run on SQL 2008. This server is a test server and they want me to match the specs with the production server (without re-installing if I can).
Any advice or tips would be greatly appreciated.