December 12, 2005 at 11:59 am
I am getting the following error just every once in a while. There doesn't appear to be a consistent time and/or preceding event when it happens. It could be during high OLTP, or while the database is relatively idle.
Error: 1105, Severity: 17, State: 2
Could not allocate space for object 'TABLE_NAME' in database 'USER_DB' because the 'GROUP_Data' filegroup is full.
ANYWAYS ... my datafile is NOT full, and it is set to autogrow by 10%. There is also ample disk space. I cannot do anything to get around the problem, but when it does happen I can bounce SQL Server and then the problem is goes away.
I am running SQL 2000 sp3a on Windows 2003 Standard sp1.
THANKS
😎
December 12, 2005 at 12:39 pm
I don't know how big your database is but in a live transaction database I would put the growth at fixed growth rather than a percentage.
I have come across this problem with TEMPDB where a single transaction would have exceeded the bounds of a single growth step. Even though TEMPDB was set to unlimited growth the database came back with Error 1105.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply