Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • 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.
0
nhmedia
Asked:
nhmedia
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
DBCC SQLPERF(LOGSPACE)
0
 
dba2dbaCommented:
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
 
Alpesh PatelAssistant ConsultantCommented:
Please increase the size of database and make sure there is space on disk to grow the database.
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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
0
 
Kevin CrossChief Technology OfficerCommented:
@sqlservr, No. SQL 2005/2008 Express have a limitation of 4GB. SQL 2008 R2 Express is increased to 10GB.
0
 
nhmediaAuthor Commented:
Thanks for the advice
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

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