[Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL Express 2008 R2 - Trying to increase a database size to 10GB

Posted on 2011-10-25
Medium Priority
Last Modified: 2012-06-27
Hi, does anyone have any experiance with SQL Express 2008 R2, we have a database that has just hit 4Gb in size and so I have tried to up the default limit to the new 10Gb offered by MS in the latest edition of 2008 R2. I can increase any of the System Databases but when I try to either manually create a new database or just to increase the current user database I get the Error 1827 which relates to the licensed limit of 4096 MB per database being breached.

Compatibility level is set to SQL Server 2008 (100)
The machine is service packed up to SP3 SQL Server 10.0.5500 and this is a new instance that I've just created....

Appears to be lots of joy on the web about the fact MS have increased the max size of 4GB to 10GB but has anyone actually managed to do it??

Many thanks
Question by:Steve_Estcourt

Accepted Solution

jonaska earned 2000 total points
ID: 37024146
Looking at 10.0.5500 it sounds like you're connectedt to a 2008 edition.
Se a table here:
Could you have installed a new instance of 2008R2 but accidentally connected to the old one?

Sure you're not using FAT32?

Author Closing Comment

ID: 37029727
Many thanks jonaska, you hit the nail on the head - I'd miss read the versions and it was only SQL express 2008 - Not the R2 Release

Downloaded R2 and all working perfectly again now.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

868 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