Assuming the recommended FULL recovery mode strategy is followed, set the database log file to be truncated when the checkpoint command is issued. The checkpoint command will be issued as a part of the backup script that should be run regularly (this process is described later) NOTE – ‘MyDatabaseName’ should be replaced with the name of the actual database USE MASTER EXEC sp_dboption @dbname = 'MyDatabaseName', @optname = 'trunc. log on chkpt.', @optvalue = 'true'