tempdb unrestricted growth

From: Tamara (anonymous_at_discussions.microsoft.com)
Date: 02/26/04


Date: Thu, 26 Feb 2004 13:11:06 -0800

I posted this message before but did not get satsifactory answer, so I am posting it again

We have tempdb set to unrestricted growth. Seems like when
log file growth request (due to a large query) is more
than 100% current size, it fails to grow. When we manually
set the size of the log to large enough number and
restricted growth, it works. Then we set it back to
unrestricted.

Any ideas?

Thank you.


Loading