PeterErhard
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
Simply restart your server to clear the tempdb.
Hope this helps,
Nito