• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Error with maximum database size?

One of our sites is throwing an error because we have exceeded the maximum database size. Every time a page is loaded an insert is made in an anyltics table.

Should  we change the DB to autogrow? How would we di this in SQL 2008?

Could not allocate space for object 'dbo.Analytics'.'PK_Anakytics' in database 'NhmMicrosites' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
2 Solutions
Ramesh Babu VavillaCommented:
is your database mdf and ldf files are on the same drives ot different

check the ldf file size by usinf
In this case the data file is full.

You have to increase the size
Setup Autogrow

Below link has more details:


If your database is an Express Edition you will have a limitation of size ,,4 GB for SQL 2008.

Alpesh PatelAssistant ConsultantCommented:
Please increase the size of database and make sure there is space on disk to grow the database.
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Ramesh Babu VavillaCommented:
MR dba2dba:

sql server 2008 express edition supports database size upto 10 GB , 4 GB is express edition of SQL Server 2005 express edition
Kevin CrossChief Technology OfficerCommented:
@sqlservr, No. SQL 2005/2008 Express have a limitation of 4GB. SQL 2008 R2 Express is increased to 10GB.
nhmediaAuthor Commented:
Thanks for the advice
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now