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)

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 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:

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:

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:

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:

For more info click here.

 

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

Loading...

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

© SQLNetHub

 

* This service was last updated on: March 6, 2018