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

Question

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

reefshark

Ten Centuries

Points: 1340
More actions
June 23, 2011 at 11:57 am

#253257

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)

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

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

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

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/

reefshark Ten Centuries Points: 1340 More actions · Answer 2

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.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

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/

reefshark Ten Centuries Points: 1340 More actions · Answer 4

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)

david.bianco Ten Centuries Points: 1148 More actions · Answer 5

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..

reefshark Ten Centuries Points: 1340 More actions · Answer 6

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!

david.bianco Ten Centuries Points: 1148 More actions · Answer 7

david.bianco

Ten Centuries

Points: 1148

June 23, 2011 at 2:38 pm

#1343395

Great, glad I could help.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 8

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