SQL Server Backward Compatibility Check (free service)

Below, you can easily retrieve useful information about the backwards compatibility support for any version of SQL Server.

Just select the SQL Server version and you will get the list of backwards compatible SQL Server versions.

 

Select SQL Server version:

    [group group-sql2k8]
    SQL Server 2008 is backwards compatible for the below SQL Server versions:

    • SQL Server 2008 (100)

    • SQL Server 2005 (90)

    • SQL Server 2000 (80)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    [group group-sql2k8r2]
    SQL Server 2008 R2 is backwards compatible for the below SQL Server versions:

    • SQL Server 2008/R2 (100)

    • SQL Server 2005 (90)

    • SQL Server 2000 (80)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    [group group-sql2k12]
    SQL Server 2012 is backwards compatible for the below SQL Server versions:

    • SQL Server 2012 (110)

    • SQL Server 2008/R2 (100)

    • SQL Server 2005 (90)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    [group group-sql2k14]
    SQL Server 2014 is backwards compatible for the below SQL Server versions:

    • SQL Server 2014 (120)

    • SQL Server 2012 (110)

    • SQL Server 2008/R2 (100)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    [group group-sql2k16]
    SQL Server 2016 is backwards compatible for the below SQL Server versions:

    • SQL Server 2016 (130)

    • SQL Server 2014 (120)

    • SQL Server 2012 (110)

    • SQL Server 2008/R2 (100)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    [group group-sql2k17]
    SQL Server 2017 is backwards compatible for the below SQL Server versions:

    • SQL Server 2017 (140)

    • SQL Server 2016 (130)

    • SQL Server 2014 (120)

    • SQL Server 2012 (110)

    • SQL Server 2008/R2 (100)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    [group group-sql2k19]
    SQL Server 2019 is backwards compatible for the below SQL Server versions:

    • SQL Server 2019 (150)

    • SQL Server 2017 (140)

    • SQL Server 2016 (130)

    • SQL Server 2014 (120)

    • SQL Server 2012 (110)

    • SQL Server 2008/R2 (100)

    Note: If you backup a database that has a different compatibility level than the native compatibility level of the SQL Server instance you are currently using, you will not be able to restore it to an older instance version. For example, if you have a database on SQL Server 2016 and has compatibility level 2014 (120), if you take a backup of that database, you won't be able to restore it to a SQL Server 2014 instance. If however, you take a backup of a database on a SQL Server 2014, you will be able to restore it to a SQL Server 2016 instance.

    Check also:

    [/group]

    For more info click here.

     

    Enroll to Our High-Quality Online Courses:

     

    Learn How to Efficiently Administer your SQL Server Databases. Get the course today!

    Check our online course on Udemy titled “Essential SQL Server Administration Tips” (special limited-time discount included in link).

    Learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

    Many live demonstrations and downloadable resources included!

    Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
    (Lifetime Access, Live Demos, Certificate of Completion, and more!)

    Learn More

    Rate this service: 1 Star2 Stars3 Stars4 Stars5 Stars (11 votes, average: 4.73 out of 5)

    Loading...

    Reference: SQLNetHub (https://www.sqlnethub.com)

    © SQLNetHub

     

    * This service was last updated on: March 31, 2022.