Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Truncating Transaction Log Guidelines

Truncating Transaction Log Guidelines

Use the following guidelines to help manage transaction logs and avoid space constraints. These options truncate transaction logs to keep them as small as possible:

• DUMP TRANSACTION statement and WITH TRUNCATE ONLY class
• DUMP TRANSACTION statement and WITH NO_LOG clause
• sp_dboption system procedure with trunc. log on chkpt. option