Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
see:… – Zypher Dec 31 '09 at 16:06
thanks, sorry for the duplicate! i HATE doing that... there was nothing that came up when I typed the question though! – alex Dec 31 '09 at 16:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.