One Command Keeps Causing "'tempdb' is full" Error

#11

Quote:

You start with 10 MB. Then it grows by 10% to 11 MB. Then it grows by
10% to 12.1 MB. After 100 autogrows, the log file is 1584 MB. If at
this stage there is not 158 MB free when the next autogrow sets in,
the autogrow fails and you get the message. But say that at this point
the operation was almost done, and all you needed was 20 more MB.
Then you get through with 10 MB increments.

Thanks for pointing out one more time the benefit of increasing the
log file by 10MB instead of by 10%.

But this doesn't explain the reason why I got that "log file of tempdb
is full" error message because I have at least 1-GB free when the
INSERT statement should only take 1 to 3 MB (at most). Therefore,
using up all the available disk space was not the cause of my original
problem.

Jay Chan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

One Command Keeps Causing "'tempdb' is full" Error

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: One Command Keeps Causing "'tempdb' is full" Error - 08-05-2003 , 11:24 AM