August 3, 2005 at 9:37 am
I have encountered an unexplained error.
*************************************
"Error 1105, severity 17, state 2"
"Could not allocate space for object
in database [db name] because 'PRIMARY' filegroup is full."
***************************************
*Disk drive on which file groups are located has ample space >63G
*database in question; tempdb and msdb ALL are set to unrestricted file growth (both data and log), and all are located on this drive with adequate space.
Searching on the web has pretty much turned up advice to increase file size or clear disk space; both of which do not seem applicable here.
...
-- FORTRAN manual for Xerox Computers --
August 3, 2005 at 10:27 am
What's the growth parameter? 10%? Is 10% > 63G?
That might be it. The other issue could be that that particular file in a filegroup is full, but the other files are not and it isn't growing. You could move some things between filegroups, or just grow that file.
August 4, 2005 at 7:46 am
Actually the db was only 11788mb in size so it would not overrun the available space, however I noticed that the size increment was only 1Mb and the single query could well increase it by more than that.
I changed it to 5% and it ran successfully last night. I'll keep an eye on it for a while.
Thx
Jay
...
-- FORTRAN manual for Xerox Computers --
August 4, 2005 at 10:46 am
Thanks for the update. Perhaps the multiple growths were causing some error. If you get a chance to test it on another box, we'd love to know what you observe.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply