Home Forums SQL Server 7,2000 Administration The log file for database 'tempdb' is full RE: The log file for database 'tempdb' is full
Steve Jones - SSC Editor
SSC Guru
Points: 734564
More actions
August 18, 2014 at 9:03 am
#1738897
I'd agree with Jason. Enlarge your tempdb log. 47MB is small and space is relatively cheap. It's not worth these errors.
I'd probably grow to 1GB and monitor the space usage in the log. Find your peak, add a small pad and then set it to that size.