Home Forums SQL Server 7,2000 Administration Could not allocate space for object 'patient' in database 'DMART' because the 'FG2' filegroup is full.. RE: Could not allocate space for object 'patient' in database 'DMART' because the 'FG2' filegroup is full..

  • That's my suspicion, that the file group was corrupted somehow and DBCC doesn't catch the problem. My fix for this was to script out each table on that file group and recreate on the Primary file group then copy all of the data over and rename the tables. The data loads to the new tables went well and I'm getting ready to drop the old table and remove that file group once it is empty.

    Thanks,

    Chris

    Learning something new on every visit to SSC. Hoping to pass it on to someone else.