September 25, 2006 at 9:15 am
Hi all, I have a problem that on the surface seems to be a no brainer: I am receiving the following message;
Could not allocate space for object 'R5TRANSACTIONS' in database 'D7IPRD' because the 'PRIMARY' filegroup is full..
This message repeats many times and I guess it must find some space because the message stops with no other errors. Checking the error log this seems to be happening intermittantly.
I checked the file properties, for this particular database the primary file group is set to 'automatically grow file', file growth is set to 10Mb and the Maximum file size is set to 'Unrestricted file growth'. There is plenty of free space on the disk (about 10Gb).
Why am I getting the space allocation message? Is it possible that I have the file growth set too low? Or is there another parameter I am not aware of that needs to be changed?
Thanks in advance for your help
Ken
September 25, 2006 at 10:51 am
You would want to check if you were out of space when the message was posted. Check the system log, if the drive did not have space then there would be messages. I do understand you say you have 10 GB. But I did see 10 GB disappear used by TempDb by a read-only user for the other database. As a tempdb, it was later recreated on the server startup to its smaller size. I also saw 4 GB disappear on the webserver when the Indexing Service was working with its catalogs. The space was returned to the hard drive in an hour. Also check if the quotas were implemented on the server.
Regards,Yelena Varsha
September 25, 2006 at 2:00 pm
Yelena,
Thank you for your response, it is right on the money! We never gave that a thought and you know our tempdb has been taking alott of space on the drive and we set a job to auto shrink the tempdb transaction log every Sunday to fix that problem. That would explain why the problem was intermitant. Thanks again
Ken
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply