February 22, 2006 at 6:29 am
Hi
For the past few days I'm getting an error for a few databases.
Autogrow of file 'templog' in database 'tempdb' cancelled or timed out after 0 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
The autogrow option is ticked for this database and the the space allocated to the log file is 1Mb and the growth is set to 10%.
Could anyone please tell me as to why this error is coming???
February 22, 2006 at 7:00 am
This is INFORMATIONAL message added in Service Pack 4.
There might be some operation going on (which caused file to grow) which was cancelled.
If you have profiler for same time, you will see attention event captured in Event Class.
February 22, 2006 at 3:31 pm
have you checked your free disk space size lately?
master..xp_fixeddrives
February 22, 2006 at 3:36 pm
It will good iif u can pre allocate the temp db size to avoid autogrow..and set the autogrow in MB instead of percent..
-Krishnan
February 22, 2006 at 3:40 pm
yes krishnan is right.... preallocate and autogrow by fixed MB is best..... the way you're set up now will eventually lead to some really nasty filesystem fragmentation.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply