title: "Primary Filegroup is Full" in SQL Server 2008 Standard for no apparent reason
body: <p>Our database is currently at 64 Gb and one of our apps started to fail with the following error:</p>
  
  <blockquote>
    <p><code>System.Data.SqlClient.SqlException</code>: Could not allocate space for object <code>'cnv.LoggedUnpreparedSpos'.'PK_LoggedUnpreparedSpos'</code> in database <code>'travelgateway'</code> because the <code>'PRIMARY'</code> 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.</p>
  </blockquote>
  
  <p>I double-checked everything: all files in a single filegroup are allowed to autogrow with a reasonable increments (100 Mb for a data file, 10% for a log file), more than 100 Gb of free space is available for the database, <code>tempdb</code> is set to autogrow as well with plenty of free HDD space on its drive.</p>
  
  <p>To resolve a problem, I added second file to the filegroup and the error has gone. But I feel uneasy about this whole situation.</p>
  
  <p>Where' the problem here, guys?</p>