January 20, 2005 at 12:06 pm
I'm running sqlserver 2000. Presently, tempdb on our server is around 800MB residing on a drive with over 13GB free. The configuration for both the temp db data file and its log file are for unrestricted, automatic growth at 10% increments. And, yet, this morning, we received an error message stating:
Error: 1101, Severity: 17, State: 10
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth.
There are no indications that any server settings would have restricted growth nor is there any indication that ample disk space was available.
Has anyone seen this problem before?
John Farrar
January 21, 2005 at 7:24 am
Since noe-one else has given you any ideas yet here are a couple of mine.
I don't reacall that error exactly, but I had a situation once where DB file growths were failing and the applications were getting error messages but the file was set to autogrow (with a %). The cause turned out to be that the DB extend could not occur fast enough and the applicaitons were timing out. The resolution was to change the file growth to a set amount - that was small enough not to cause application errors. AND manually grow the file in a large chunk for what was really needed now.
In your case, the size of the DB doesn't seem that it could the same problem - but it's a thought you might test.
Have you considered security? Is the account running SQL able to log in properly- now? Have passwords changed or anything like that since you restarted SQL? I don't know if it would cause this problem - but you don't mention how the security is configure or if it could have possibly changed.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply