Backup & Restore Error in MS SQL Server 2016 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 running
  version 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.