SQL Server Version History

By default you can’t restore a sql backup that was taken from a higher version sql server. Otherwise you might get following error when doing restore.

System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2714. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server

SQL Server version can be checked by running following sql query

SELECT @@Version

SQL Server Version History Tracking Table

Version SQL Server Release
12.00.2000.8 SQL Server 2014 RTM
11.00.3000 SQL Server 2012 SP1
11.00.2100.6 SQL Server 2012 RTM
10.50.4000 SQL Server 2008 R2 SP2
10.50.2500 SQL Server 2008 R2 SP1
10.5.1660.1 SQL Server 2008 R2 RTM
10.00.5500 SQL Server 2008 SP3
10.00.4000 SQL Server 2008 SP2
10.00.2531 SQL Server 2008 SP1
10.00.1600.22 SQL Server 2008 RTM
9.00.5000 SQL Server 2005 SP4
9.00.4035 SQL Server 2005 SP3
9.00.3042 SQL Server 2005 SP2
9.00.2047 SQL Server 2005 SP1
9.00.1399.06 SQL Server 2005 RTM
8.00.2039 SQL Server 2000 SP4
8.00.0760 SQL Server 2000 SP3
8.00.0534 SQL Server 2000 SP2
8.00.0384 SQL Server 2000 SP1
8.00.0194 SQL Server 2000 RTM

Leave a Reply

Your email address will not be published.