Knowledge Essentials - 3Essentials Hosting

ERROR: Could not allocate space for object in database because the PRIMARY filegroup is full

Article ID: 684

 Back to Search

Problem: Receiving an error similar to the following in a website where you use a MSSQL database:

Could not allocate space for object SOME-OBJECT in database SOME-DATABASE because the 'PRIMARY' filegroup is full
For Example:
File Error  Could not allocate space for object 'dbo.EventLog'.'PK_EventLogMaster' in database 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.

Resolution: Your MSSQL database has reached the maximum allowable size.  You will need to reduce the size of the database.

  • The most common reason for these types of errors:
  • Redcue the size of the database:
    • Use the webadmin utility in your control panel. To use the WebAdmin tool in the control panel
    • In the control panel, under Databases, you will see a list of the databases on that domain. To the far right is a link to the webadmin tool.

    • This opens myLittleAdmin for SQL Server. Once there, open the User Databases branch on the left hand menu. You will see your database in the list. You can then click on it.
    • From here you can manage the database.

    • To run a SQL query click on the Tools menu on the lower left to bring up the New Query option. Here you can use a simple SQL query to truncate the tables. Once you enter the query, use the Submit button.
      • truncate table EventLog;
        truncate table ScheduleHistory;
        truncate table SiteLog;


Downloads Associated With This Article
No downloads are currently associated with this article.