Solved

Error with maximum database size?

Posted on 2011-09-16
6
240 Views
Last Modified: 2012-05-12
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.
0
Comment
Question by:nhmedia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 36548219
is your database mdf and ldf files are on the same drives ot different

check the ldf file size by usinf
DBCC SQLPERF(LOGSPACE)
0
 
LVL 8

Accepted Solution

by:
dba2dba earned 300 total points
ID: 36548931
In this case the data file is full.

You have to increase the size
or
Setup Autogrow

Below link has more details:

http://www.sqlservercentral.com/Forums/Topic242179-5-1.aspx#bm242240

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

Thanks,
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 36549124
Please increase the size of database and make sure there is space on disk to grow the database.
0
Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 200 total points
ID: 36549155
MR dba2dba:

sql server 2008 express edition supports database size upto 10 GB , 4 GB is express edition of SQL Server 2005 express edition
0
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 36549193
@sqlservr, No. SQL 2005/2008 Express have a limitation of 4GB. SQL 2008 R2 Express is increased to 10GB.
0
 

Author Closing Comment

by:nhmedia
ID: 36549246
Thanks for the advice
0

Featured Post

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question