SQL 2008 and/or 2012-- is backwards compatibility possible to open 2005 databases?

Posted on 2014-08-07
Last Modified: 2014-08-12
SQL 2008 and/or 2012-- is backwards compatibility (BC) possible to open 2005 databases? I have some DBAs that are going to need to work with DBs created with 2005. They've been trying to get BC working and testing with 2005 DBs, but doesn't seem to be working. Any ideas?

Question by:dlewis61
    LVL 23

    Accepted Solution

    What is it that you would like to do?? Normally you can just restore or import a database of an older SQL version and the newer SQL version will automatically use a different compatibility mode (2005 is 90). So this should be possible.
    LVL 68

    Assisted Solution

    The newer version of SQL must upgrade the databases to its version when they are restored / attached.  You can specify SQL 2005 compatibility level, which applies to certain elements of syntax.  But the db itself has been converted to the upper level.  Therefore, for example, that db could not be detached from 2008/2012 and attached back to 2005.
    LVL 23

    Expert Comment

    That's true indeed, but restoring the database would do the trick.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 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

    17 Experts available now in Live!

    Get 1:1 Help Now