THe log file for database "tempdb" is full. Backup the transaction log for the database

I'm getting errors every now and then saying "THe log file for database "tempdb" is full. Backup the transaction log for the database
to free up some log space".

There's 25GB free on the drive, and I can't see why I could be getting these errors. Below are some screenprints of the settings:

http://www.files2net.com/files/228157975/1.JPG

http://www.files2net.com/files/67572126/2.JPG

http://www.files2net.com/files/22261897/3.JPG

http://www.files2net.com/files/244513644/4.JPG

http://www.files2net.com/files/227509550/5.JPG

Why would this be happening and what can I do to solve it?
PeterErhardAsked:
Who is Participating?
 
nito8300Connect With a Mentor Commented:
Hi again.  If you can restart the server then do this:  http://support.microsoft.com/?id=307487

Take care.
0
 
nito8300Commented:
Hi there.
Simply restart your server to clear the tempdb.

Hope this helps,
Nito
0
 
imran_fastCommented:
hi,

Change the data file size and the log file size to be 100 MB each
and select option automatic grow file
in megabytes
and put the value 50MB there.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.