469,588 Members | 2,741 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,588 developers. It's quick & easy.

tempdb log full

Tom
I received an error that the log in tempdb was full, but the log and
data segments are set to automatically grow with no limit AND there is
plenty of available space on the disk. So I don't understand why this
error occurred. Does anyone have any ideas?

Thanks,

Tom
Jul 20 '05 #1
2 3743
Hi

Did this say it was full or could not grow? If the latter check out how the
amount of disc space available. You may also want to review how you are
using tempdb.

John

"Tom" <zi**********@bloglines.com> wrote in message
news:5b*************************@posting.google.co m...
I received an error that the log in tempdb was full, but the log and
data segments are set to automatically grow with no limit AND there is
plenty of available space on the disk. So I don't understand why this
error occurred. Does anyone have any ideas?

Thanks,

Tom

Jul 20 '05 #2
Tom (zi**********@bloglines.com) writes:
I received an error that the log in tempdb was full, but the log and
data segments are set to automatically grow with no limit AND there is
plenty of available space on the disk. So I don't understand why this
error occurred. Does anyone have any ideas?


Do you have tempdb set to autoshrink? In this case, if tempdb grows
because of a wild transaction, the log will shrink once the wild
transaction is rolled back, because it ran out of disk space for
the log.

Another possibilty is that even if there is plenty of disk space, it may
not be plenty enough. 150 MB may seem plenty, but if the tempdb log
is 2 GB, and autogrow is set to the default 10%, autogrow will fail.
--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Senthuran | last post: by
8 posts views Thread by arijitchatterjee123 | last post: by
3 posts views Thread by Kurt | last post: by
2 posts views Thread by Thomas R. Hummel | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.