Not for Beginners – SQL 2005 Database Error Handling

SQL 2005 database created and used by default by Outlook 2007 with BCM. Recently ran into the infamous error message “Could not allocate space for object … 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.”

Yet the database was less than 3 GB, plenty of space and autogrowth was set to true. But for some reason the autogrowth setting was set to 50% (by default, I never changed that setting) and when I changed that to increase by 10 MB instead, magically the error disappeared.

My best guess is that growing a 3 GB database by 50% would put it over the 4 GB limit for a SQL 2005 database. But it’s just a guess. 

Leave a Reply

Your email address will not be published. Required fields are marked *