?
Solved

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

Posted on 2012-08-26
5
Medium Priority
?
530 Views
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.....
0
Comment
Question by:JenebyM
  • 3
  • 2
5 Comments
 
LVL 16

Accepted Solution

by:
DcpKing earned 2000 total points
ID: 38335148
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.

hth

Mike
0
 

Author Comment

by:JenebyM
ID: 38335904
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.

Cheers
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 38336120
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!

hth
0
 

Author Comment

by:JenebyM
ID: 38338505
Mike,

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.
Jen
0
 
LVL 16

Expert Comment

by:DcpKing
ID: 38339190
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!
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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
Suggested Courses

850 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