I have a backup from SQL Server 2016. I want to restore it in my pc but I am getting this error.
The database was backed up on a server running
version 13.00.1400. That version is incompatible with this server, which is runningversion 11.00.5343.
I have searched in Google and have try to upload some patches but it's still the same.How can I fix it.
The error message
The database was backed up on a server running version 13.00.1400. That version is incompatible with this server, which is running version 11.00.5343.
means that you are having backup of sql server 2016 RC3 --> 13.00.1400 and you are trying to restore it on your PC which is running 11.00.5343 --> sql server 2012 SP2 + GDR 3045321 fix.
Restoring the database from higher version to lower version is not supported using backup restore or attach/detach methods.
A RESTORE HEADERONLY FROM DISK = 'X:\yourBackupFile.bak' will give you the major, minor and software version build numbers that you can confirm.
Downgrading database is a pain !
Best is to install FREE DEV sql server 2016 RTM + CU1 on your PC machine and restore the backup.
