MS SQL Back up not restore the MS SQL 2014?
You are trying to restore a database that was backed up from a version of sql server that's Enterprise and is using Enterprise features like data compression - my guess is you are trying to restore this backup to either Standard or Express which don't support those Enterprise features until Sql 2016 SP1 - if possible, upgrade your 2014 edition to 2016 SP1.

The steps involved in upgrading are too numerous for this Q/A environment.

If you decide to upgrade, check the information in this link Upgrade SQL Server.  Additional information can be found by searching for 


  upgrade sql 2014 to 2016


Sql 2016 SP1 has a number of features available in ALL Sql Server editions (Standard, Express, etc.) that used to be only available in Enterprise edition.  For more information on those new features, please check 

SQL Server 2016 Service Pack 1 (SP1) released

Upgrading from one release of Sql Server to another needs planning and testing to prevent unexpected surprises.  

Instead of upgrading the current Sql Server 2014 environment that you are trying to restore to, you might be better off installing a brand new Sql Server 2016 Express instance and applying SP1 to that new install.  Then restore your database to that new instance.  Be aware that Sql Server 2016 Express edition can only accommodate database sizes of 10GB, so depending on the size of the database you are trying to restore - that may limit your ability to use Sql Server Express