Post reply

primary filegroup is full

  • December 12, 2007 at 8:55 am

    #70529

    I was trying to make a change on data type of a column. I got an error the job is terminated because of the primary filegroup is full. I checked the database properties. Both size growths were set autogrow. There is enough free space on the disk. What might be possible problems?

    Any input will be greatly appreciated.

  • December 12, 2007 at 9:10 am

    #759454

    There are some things that "time out" before the autogrow finishes. I think this might be one.

    Try to increase the size of the filegroup and see if that helps. I think that's what's worked before.

  • December 18, 2007 at 7:13 am

    #761005

    Hi,

    Wht ever steve has suggested will work. In past same i have fixed this kind of issue with the same way.

  • October 5, 2010 at 7:48 am

    #1231705

    Hi,

    Please check your autogrowth of your data files if you have many either you need work with the Autogrowth settings accroding to your conveninence some time you may get an error like Primary FG is full could not allocate space for the Object if nothings works you have to add additonal files to your FG.

    Regards,

    Uday

  • October 5, 2010 at 8:11 am

    #1231722

    If you add another file, you'll need to make it the default, so that new objects are created there.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply