Question

The following error is occurring when FogBugz attempts to import mail from my POP3 server:

Could not allocate space for object 'dbo.BugEvent'.'BugEventPrimaryKey' in database 'fogbugz' 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.'

I have plenty of disk space on the server, so I'm not sure why I'm getting this error. I'm using MS SQL Express as my database engine.

Answer 1

My first thought was that I might not have AutoGrow enabled. I also checked to see if my transaction log needed to be shrunk. Nope, all good.

It turns out that that I was brushing up against SQL Express' maximum database size of 4GB. I upgraded to SQL Server 2008 and now everything is working fine.