June 14, 2011 at 12:09 pm
Hello,
I have a test box I am working with and installed SQL 2008 express and created a blank DB on it. I tried to restore from a backup, which is 5.6 Gb, and I get the following error:
System.Data.SqlClient.SqlError: CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 MB per database. (Microsoft.SqlServer.Smo)
Everywhere I have checked says the DB file size can go up to 10 Gb in SQL 2008 express, yet I get this error trying to restore one half that size.
Any ideas?
June 14, 2011 at 12:11 pm
June 14, 2011 at 12:14 pm
June 14, 2011 at 12:18 pm
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
Gives 4GB as max database size
June 14, 2011 at 12:19 pm
Yes, I believe that is where my confusion is. SQL 2008 express R2 has the 10 Gb, I downloaded the regular sql 2008 express.
Thanks 🙂
June 14, 2011 at 12:38 pm
bitbucket-25253 (6/14/2011)
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspxGives 4GB as max database size
Think that's a MS typo? That page references SQL Server 2008 versions and breaks down the free editions into compact and express. Compact lists the 4gb max and Express shows 10gb.
The next page for Express versions says the limit is 4gb storage.
Limitations
SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage
June 14, 2011 at 12:56 pm
calvo (6/14/2011)
bitbucket-25253 (6/14/2011)
http://www.microsoft.com/sqlserver/2008/en/us/editions.aspxGives 4GB as max database size
Think that's a MS typo? That page references SQL Server 2008 versions and breaks down the free editions into compact and express. Compact lists the 4gb max and Express shows 10gb.
The next page for Express versions says the limit is 4gb storage.
Limitations
SQL Server Express supports 1 physical processor, 1 GB memory, and 4 GB storage
calvo (6/14/2011) OOPS I stand corrected
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply