Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL server uses up my harddrive, templog.ldf is several Gb.

Issue

SQL server uses up my harddrive, templog.ldf is several Gb.

Environment

SQL Express 2005

Cause

In SQL there are some system databases used by the server when administrating data within the server.
If you run SQL server for several months without restart, templog.ldf will grow

Resolution

By adding growth restrictions for tempdb this will not be a problem. Most sites do not have these problems as updates, etc., usually force restarts of the computer.

Tags (1)
Labels (1)
Version history
Revision #:
1 of 1
Last update:
‎2018-09-06 02:26 PM
Updated by: