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:
  • The EventLog, SheduleHistory, and/or SiteLog tables have grown excessively. These tables will need to be truncated. However, this issue will reoccur unless some steps are taken to manage these tables.
     
  • DNNCreative has a very useful tutorial on working with these logs and managing them
    • http://www.dnncreative.com/Sitelogseventlogsscheduler/tabid/343/Default.aspx
       
  • Mitchell Sellers also has some advice on managing your DNN application
    • http://mitchelsellers.com/blogs/2009/01/05/how-i-get-my-dotnetnuke-sites-to-run-so-fast.aspx
       
• 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;
      
       
    •