Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database size exceeds license limit of 4096MB per Database error Expand / Collapse
Author
Message
Posted Tuesday, July 24, 2012 6:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 10, 2013 2:35 AM
Points: 4, Visits: 24
Hi,

I have installed SQL Express 2008 Express version on one of my staging server.

But one of the database on above mentioned server was previously set to "SQL Server 2005(90)" compatibility level in Option section. and I am getting the Database size exceeds license limit of 4096MB per Database error while rebuilding the Indexes.

Now I have changed the compatibility level in Option section to "SQL Server 2005(100)". But still I am getting the same above error.

Following are my SQL Server version information:

Microsoft SQL Server Management Studio = 10.0.2531.0
Instance ID = MSSQL10.SQLEXPRESS
Microsoft Data Access Components (MDAC) = 6.1.7600.16385
Microsoft MSXML = 3.0 6.0
Microsoft Internet Explorer = 8.0.7600.16385
Microsoft .NET Framework = 2.0.50727.4971
Operating System = 6.1.7600

As I am having sql express 2008 Express version installed, my database size should have max 10GB size not 4GB.

Please help me...
Post #1334427
Posted Tuesday, July 24, 2012 7:04 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 2:37 AM
Points: 5,075, Visits: 4,834
2008 has a limit of 4GB

2008R2 has a limit of 10GB.





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1334437
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse