0

I have a SQL Server 2008 R2 database, about 7 GB I make a backup from SQL Server2008R2 and tried to restore it to SQL Server2014 Express getting an error:

CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database

what steps should i follow to avoid that problem?

2

The backup is 7GB? What are the sizes of the MDF files before the backup? That is what Express Edition checks - it doesn't care about the size of the backup file, it cares about how big the data files are that it has to put on the disk.

If this is for a production instance of SQL Server 2014 Express Edition, you're going to have to go back to the source and shrink those data files - it might be that they are larger than 10GB but not full, or it might be that you'll need to actually clear out some of the data.

If this is for local development, I suggest using SQL Server 2016 Developer Edition, which is free - and doesn't have any silly limits on file size.

2
  • Mydb_Dat file size is 89858 MB .what is safe way to clear some data and do you think after shrinking it will help ?@Aaron Bertrand – shamim Feb 3 '17 at 21:50
  • 1
    Your data file is 89 GB? Yeah, you can't restore that on Express. And I have no idea if you are able to get that down to < 10 GB, or how you would go about it... I have no idea what your data looks like, which data you need to keep, etc. – Aaron Bertrand Feb 3 '17 at 22:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.