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

Posted on 2011-10-25
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
    LVL 6

    Accepted Solution

    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

    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

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    731 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

    18 Experts available now in Live!

    Get 1:1 Help Now