SQL Server 2008 R2 Express giving error for 4GB database limit

  • Has anyone come across this? We have 2008 R2 Express installed, but have encountered this error:

    "CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database"

    Isn't the the Express version of 2008 R2 supposed to allow for a 10 GB database?

    Our version: 10.0.2573.0 (X64)

  • reefshark (6/23/2011)


    "CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database"

    Isn't the the Express version of 2008 R2 supposed to allow for a 10 GB database?

    Our version: 10.0.2573.0 (X64)

    10GB is the Limit for SQL Server 2008 R2 Express and 4GB is the limit for the Express 2008.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • I thought the 2008 R2 Express version has a 10GB limit.

    10.0.2573.0 (X64) is not 2008 R2 Express? I couldn't find any build lists to verify.

  • reefshark (6/23/2011)


    I thought the 2008 R2 Express version has a 10GB limit.

    10.0.2573.0 (X64) is not 2008 R2 Express? I couldn't find any build lists to verify.

    Are you connect to the instance of SQL Server, and then run the following query:

    Select @@version

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • Welsh Corgi (6/23/2011)


    Are you connect to the instance of SQL Server, and then run the following query:

    Select @@version

    Yes, that is how I got my version info: Microsoft SQL Server 2008 (SP1) - 10.0.2573.0 (X64)

  • Does this help?

    http://support.microsoft.com/kb/321185

    10.0.xx is 2008, while 10.50.xxx is R2.

    Edit for stupid URL tags..

  • david.bianco (6/23/2011)


    Does this help?

    http://support.microsoft.com/kb/321185

    10.0.xx is 2008, while 10.50.xxx is R2.

    Edit for stupid URL tags..

    Thanks, David. This helps. I guess we really did not have R2 installed. Very strange because the splash screen for SSMS shows R2, and I am accessing SSMS on the server that the database resides on.

    Thanks, again, for the help!

  • Great, glad I could help.

  • Considering that SSMS is not delivered with Express, I'm guessing they installed 2008 Express and later installed the tools from R2.

    Hate it when this happens.

    CEWII

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply