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:

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:

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)

Check also:

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)

Check also:

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)

Check also:

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)

Check also:

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)

Check also:

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)

Check also:

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!

(Lifetime Access, Live Demos, Certificate of Completion, and more!)

Learn More

Rate this service: (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.

Cookie	Duration	Description
cookielawinfo-checkbox-analytics	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional	11 months	The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance	11 months	This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy	11 months	The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.