?
Solved

Error with maximum database size?

Posted on 2011-09-16
6
Medium Priority
?
243 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 1200 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 10

Assisted Solution

by:Ramesh Babu Vavilla
Ramesh Babu Vavilla earned 800 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

771 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