SQL Server 2014 Backup Restore Error (Version 12.00.2000) to Early Version


If you try to restore a backup taken from SQL Server 2014 server, you will run into incompatibility problem.
Just like before, you cannot restore SQL Server 2014 backup to early version.
The error looks like below:

Restore of database ‘xxx’ failed.
The database was backed up on a server running version 12.00.2000.
That version is incompatible with this server, which is running version 11.00.2218.



Leave a comment