log for tempdb is full

Last Post 20 Oct 2008 10:41 AM by Markus_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

20 Oct 2008 10:41 AM
I have a SS2000 SP4 running a helpdesk application. Today I found this message in the log:

Error: 9002, Severity: 17, State: 6
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.

The .ldf file is set to autgrow at 15mb at a time and it was only consuming 20mb of space. Autoshink is not set on the db properties nor is it scheduled.

The drive that temp mdf and ldf files are on has 2 gig of free space...

Any ideas? I did run this that I found doing some research.

backup transaction tempdb with truncate_only

Acceptable Use Policy