Previous Topic: When to Use DUMP TRANSACTION Statement and WITH TRUNCATE ONLY ClassNext Topic: When to Use sp_dboption System Procedure with trunc. log on chkpt. Option

Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Truncating Transaction Log Guidelines › When to Use DUMP TRANSACTION Statement and WITH NO_LOG Clause

When to Use DUMP TRANSACTION Statement and WITH NO_LOG Clause

Use the DUMP TRANSACTION statement using the WITH NO_LOG clause only when you have run out of space in the database and cannot execute DUMP TRANSACTION using the WITH TRUNCATE_ONLY option. If you use the WITH NO_LOG option, follow the DUMP TRANSACTION with a DUMP DATABASE statement, or you will be unable to recover future transaction logs.