Restore from SQL Server 2008 R2 to SQL Server 2014 fails
You will not be able to restore a database from Microsoft SQL Server 2008 (paid version) to Microsoft SQL Server 2014 Express (Free version) due to its database file limit.

For others who need reference

SQL Server Express versions have a hard size limit on the database size.

I have listed them below from 2000-2008_r2


MSDE "SQL Server 2000" 2gig free limit
SQL Server 2005 4Gig free limit
SQL Server 2008 4gig free limit.
SQL Server 2008 R2 and newer: 10gig free limit.


Please upgrade to SQL Server 2014 (Paid version) to resolve this issue.