I have a SQL Server database backup of SQL Server 2008 R2. I want to restore that backup file that is around 40 GB on to a Microsoft SQL Server 2014 Express Edition (64-bit) and it runs till 95% and then gives me this error:
CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database
-
6Per the error message, SQL Express has a size limit of 10GB, so you can't put a 40GB database there. google.co.uk/webhp?q=sql%20express%20size%20limit%202014JohnLBevan– JohnLBevan2015年09月11日 12:22:34 +00:00Commented Sep 11, 2015 at 12:22
-
5Only solution is to purchase SQL (developer edition's included with MSDN), or to decrease the size of the database you're recovering (i.e. by deleting stuff you don't care about and shrinking it before taking a backup; but deleting stuff may not be a viable option).JohnLBevan– JohnLBevan2015年09月11日 12:24:28 +00:00Commented Sep 11, 2015 at 12:24
-
Possible dublicate of Unable to restore .bck files on SQL Server 2014 Express editionRoman Marusyk– Roman Marusyk2015年09月11日 14:18:05 +00:00Commented Sep 11, 2015 at 14:18
1 Answer 1
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.
-
1Your list has incorrect - the increase from 4 to 10 GB came with SQL Server 2008 R2 Express (not 2008 Express) - fixedmarc_s– marc_s2015年09月15日 10:15:16 +00:00Commented Sep 15, 2015 at 10:15