Solved

Error with maximum database size?

Posted on 2011-09-16
6
236 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
6 Comments
 
LVL 10

Expert Comment

by:sqlservr
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
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 10

Assisted Solution

by:sqlservr
sqlservr 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 59

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql help 8 61
Union 2 queries to a cte (temp table perhaps) 9 49
Stored Proc - Rewrite 42 70
Getting local user timezone in Sql Server 5 28
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

679 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