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
You must be logged in to post a comment.