I'm out of ideas here. When I was first alerted to this situation on a legacy SQL 2000 box I inherited, I found that the data files on it had auto-growth turned off. I turned it on for 2 additional data files, with 500MB increment for auto growth. We then attempted the same data load process that generated that error and got the same thing. I grew the files manually so that the file in the file group in question now has 4.1G free but I still get the same error.
The disk has about 100G free on it. Al files are stored on the same LUN and the DB is online and working.
I also tried to shrinkfile and empty that extra filegroup, but I got a variation of the same thing:
Msg 1105, Level 17, State 2, Line 1
Could not allocate space for object 'rxRej_Excep' in database 'DMART_MACAID' because the 'FG2' filegroup is full.
CheckDB and CheckFileGroup yielded no errors. UpdateUsage on this DB made a lot of updates, as no regular maintenance is scheduled, but it made no difference in the errors.
I have run out of ideas on this one.
name fileid filegroup size maxsize growth usage
DMART 1 PRIMARY 458037248 KB Unlimited 2097152 KB data only
DMART_log 2 NULL 504 KB Unlimited 102400 KB log only
DMART_Data2 3 PRIMARY 26624000 KB Unlimited 512000 KB data only
FG2Data 4 FG2 26624000 KB Unlimited 512000 KB data only
I plan to bounce the server this evening, to see if that makes a difference. I tried just taking it offline and bringing it back on but it had no effect.
Learning something new on every visit to SSC. Hoping to pass it on to someone else.