June 23, 2011 at 11:57 am
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)
June 23, 2011 at 12:09 pm
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/
June 23, 2011 at 12:15 pm
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.
June 23, 2011 at 12:21 pm
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/
June 23, 2011 at 12:51 pm
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)
June 23, 2011 at 2:09 pm
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..
June 23, 2011 at 2:36 pm
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!
June 23, 2011 at 2:38 pm
Great, glad I could help.
June 23, 2011 at 4:18 pm
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