Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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
1  
see: serverfault.com/questions/98352/… –  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

 
discard

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

Browse other questions tagged or ask your own question.