SQL Express 2008 R2 - Trying to increase a database size to 10GB
Posted on 2011-10-25
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??