windows 2003 standard to windows 2008 enterprise 32bit
I need to upgrade a windows standard 2003 R2 server to Windows 2008 32bit. There are MS SQL 2000 and 2005 running on this server too.
I like to do this upgrade inplace first so I can add extra RAM to speed it up. If it still is slow then I might purchase a new server. Then Definitely I will install 2008 64 bit on that.
I need you advise me how to do inplace upgrade after making a good backup. Do I need to do anything with MS SQL 2000 and 2005? Am I going to have any compatibility problems?
I also need your advise for my last choice going with a new 2008 64bit. Am I going to have difficulties with installing MS SQL 2000 and 2005 on the new server? Considering the 64bit OS?