SQL Server Performance

Primary Filegroup FULL

Discussion in 'SQL Server 2005 General DBA Questions' started by mvsandhya, Jun 18, 2009.

  1. mvsandhya New Member

    Hi,
    For one of my databases, I am getting a message the following message:
    Could not allocate space for object <object> in database <dbname> 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.
    But the datafile in the Primary file group is set to 'autogrowth' enabled and there is almost 60gigs free space in the drive. After getting this message, I changed the growth parms for that db file from 1000 MB to 10% growth. But that too did not work. Can someone please help?
    Regards
    Sandhya
  2. Sandy New Member

    Hi Sandhya,
    You can have few option like DBShrink, Increase filegroup size.
    I think Frank or Satya can guide you better.
    Thank you,
    Sandy.
  3. arunyadav Member

    Though the autogrow option is checked, Check if filegrowth is unrestricted or, you have restricted it to a certain limit.If yes, set it to unrestricted or, increase the limit.
  4. mvsandhya New Member

    Filegrowth is in unrestricted mode.
  5. arunyadav Member

    This can be the issue with Log file and not only the data file.. Check the below link... this must apply to SQL 2005 as well.

    http://www.banmanpro.com/support/filegroupfull.asp
  6. arunyadav Member

    Last but not the least..
    Check the below links...
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=10069
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=5853
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11265
    http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8846

    and refer File Group Performance related article also :
    http://www.sql-server-performance.com/ac_filegroup_performance.asp

Share This Page