Can I restore a MS SQL 2005 DB to a MS SQL 2000 DB using built-in restore (downgrade)?

I just moved over my DB from MS SQL 200 to MS SQL 2005 and now I'm getting the odd error;
Brief Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I was wondering if it's possible to backup the 2005 DB and restore back on my 2000 machine?
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
I think I have to disagree, but I might be wrong (I actually never tried that out).
once you restored/attached a database on sql 2005, you cannot go back AFAIK
If you set the database compatibility down to 80 (SQL 2000), you should be able to easily downgrade the database and restore it on the 2000 machine.  Provided you haven't used any 2005 specific features yet.
NightmanConnect With a Mentor CTOCommented:
angelIII is correct - you cannot restore a 2005 database on a SQL 2000 server. The internal structures of the database will have been changed as part of the upgrade, and this is not compatibile with SQL 2000.
davecorunConnect With a Mentor Commented:
You could export the data to a common format, and then re-import into the SQL 2000 database if setting the compatibility doesn't work.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.