Cumulative database size would exceed your licensed limit of 10, 240 MB per database

Posted on 2012-08-26
Last Modified: 2012-08-27
I am getting the above message while trying to restore a 2.5 GB database.

The original backup file was created in the production environment that has SQL Server 2012 Standard edition.

We need to restore this in a development server that has SQL Server 2012 Express edition installed.

2.5GB is obviously way below the 10GB limit. Is there a reason for this error?  

Please help.....
Question by:JenebyM
    LVL 16

    Accepted Solution

    Is it the backup file that's 2.5 GB? If so, it might be compressed, and tghe restore may be quite a bit bigger. Look at the RESTORE FILELISTONLY command in the BoL - I think that should let you see how big the database is going to be without actually restoring it.



    Author Comment

    Thanks Mike,

    I looked at the RestoreFileListOnly. This clearly shows the file at 19GB before compression.

    Thanks for your help. My next questions relates to the log files that is 26GB. I will post elsewhere when ready with that.

    LVL 16

    Expert Comment

    Sounds like you need to make a backup of the database and log file, Jen, and then reduce it in size. Look in BOL for "Manage the Size of the Transaction Log File".

    BTW, if this is really a development server, and won't be used for production purposes, you can use SQL Server Developer Edition instead of Express Edition. Yes, it's more expensive - about $50 from Amazon! - but you get all the features of Enterprise Edition for that!


    Author Comment


    Yes - It is a real development server. That is why we licensed the production server that has 19.5 GB and not bothered to licence the development server that has this limitation. The Amazon tip is certainly something new for me and I should have marked that as the answer but read this after I had closed the question.

    As suggested, I have created a test database on the production server and restored the 19GB file. I then deleted one large table (Which contains all the pdf, word an excel documents saved to the table in binary)  - that alone reduced the database to 1.2GB! This is now the one we are using in the development server. (minus one table) and we will deploy a developer license long term.

    Thanks mike. Good tips.
    LVL 16

    Expert Comment

    Hi Jen,

    My pleasure! I can't ever say I'm a SQL Server guru, but I've been problem-solving computer software problems since about 1973 ...... still having fun :)

    Have a great day!

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now