[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 956
  • Last Modified:

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?
0
PeterErhard
Asked:
PeterErhard
  • 2
1 Solution
 
nito8300Commented:
Hi there.
Simply restart your server to clear the tempdb.

Hope this helps,
Nito
0
 
nito8300Commented:
Hi again.  If you can restart the server then do this:  http://support.microsoft.com/?id=307487

Take care.
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now