The log file for database 'tempdb' is full.

[Naith]

Hi,

I'm attempting to execute a fairly large insert, and coming up against:

Server: Msg 9002, Level 17, State 2, Line 3
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.
The statement has been terminated.

At first, I thought this might be because space on the local server disk was compromised. However, I increased available space from 1GB to 160GB.

After executing a statement to backup the tempdb log with truncate only, and setting the transaction log for templog to automatically grow to an unrestricted size, I still get the error.

Can anyone give me some idea of what else to check?

Thanks,

Naith

 

[Naith]

Never mind.

I increased the original file allocation, independent of the growth allowance, and this got the two thumbs up.