Minimizing Log File Space Usage

A log file may fill quickly (thus halting the server) if there is a large volume of activity on a SQL Server database. You can set the log file to Truncate on Checkpoint to significantly extend the life of the log file for a database.

To enable Truncate on Checkpoint

1. Run Microsoft SQL Server Enterprise Manager.
   
   
2. Open the tree for the Server.
   
   
3. Open the Databases tree.
   
   
4. Double-click the name of the database on which this feature will be enabled.
   
   
5. On the Database tab, click Truncate.
   
   
6. On the Options tab, select Truncate Log on Checkpoint, and then click OK.

See Also   For more information about the Truncate on Checkpoint feature, see the Microsoft SQL Server documentation.