I have an application that currently runs on SQL 2000, on a server with Windows 2000. The hardware has just about run out of useful life - HD's are almost full, more users than 2gb ram can cope with etc...
I've got it's replacement ready. It's Windows Server 2008 x64 - Which I cannot install SQL 2008, as it isn't compatible.
We're in the process of upgrading to SQL 2008 across our organization. My question is - I've installed SQL 2008 onto this machine. My idea is to create a database on this, in 2000 compatibility mode.
Will this work....? In terms of "old" or depreciated queries etc... (I'm not sure if there are any)
Is this my best bet?