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

Posted on 2007-08-12
Last Modified: 2012-08-13
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?
Question by:juliandormon
    LVL 8

    Expert Comment

    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.
    LVL 142

    Accepted Solution

    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
    LVL 30

    Assisted Solution

    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.
    LVL 8

    Assisted Solution

    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.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now