1

Sometimes, when there is no load on the server, the size of the MS SQL database tempdb log file (templog.ldf) starts increasing. As a result, the available space on the C drive decreases. To resolve this issue, we need to restart the MS SQL server, after which the problem will be resolved. However, the same issue may repeat after some time when there is no load on the server.

Please suggest why the log file size starts increasing and how to fix this issue.

Improve this question
2
  • You can usually see in select * from sys.databases what prevents log from shrinking. a better alternative is to set max log size. If it's still increasing, it means there's something generating the log data, perhaps there's some sort of "load" after all
    – siggemannen
    Commented Jun 7, 2023 at 11:57
  • 1
    See dba.stackexchange.com/questions/271860/… and dba.stackexchange.com/questions/29829/…. You should really consider upgrading: SQL2005 went out of support 7 years ago in 2016
    – Charlieface
    Commented Jun 7, 2023 at 12:59
Related questions
3282
How to add a column with a default value to an existing table in SQL Server?
4285
How do I UPDATE from a SELECT in SQL Server?
1643
How can I do an UPDATE statement with JOIN in SQL Server?
Load 7 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.