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.
Important
Beginning with Windows 8 and Windows Server 2012, RDS server components are no longer included in the Windows operating system (see Windows 8 and Windows Server 2012 Compatibility Cookbook for more detail). RDS client components will be removed in a future version of Windows. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Applications that use RDS should migrate to WCF Data Service.
To enable Truncate on Checkpoint in Microsoft SQL Server 6.5
Start Microsoft SQL Server Enterprise Manager, open the tree for the Server, and then open the Database Devices tree.
Double-click the name of the database on which this feature will be enabled.
From the Database tab, select Truncate.
From the Options tab, select Truncate Log on Checkpoint, and then click OK.
To enable Truncate on Checkpoint in Microsoft SQL Server 7.0
Start Microsoft SQL Server Enterprise Manager, open the tree for the Server, and then open the Databases tree.
Right-click the name of the database on which this feature will be enabled and choose Properties.
From the Options tab, select Truncate Log on Checkpoint, and then click OK.
For more information about the Truncate on Checkpoint feature, see the Microsoft SQL Server documentation.