Database size exceeds license limit of 4096MB per Database error

• nishantshende-532951

  SSC Enthusiast

  Points: 180

  More actions

  July 24, 2012 at 6:49 am

  #392817

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

• Ant-Green

  SSC Guru

  Points: 113544

  More actions

  July 24, 2012 at 7:04 am

  #1516762

  2008 has a limit of 4GB

  2008R2 has a limit of 10GB.