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

When to Use DUMP TRANSACTION Statement and WITH TRUNCATE ONLY Class

The DUMP TRANSACTION statement using the WITH TRUNCATE_ONLY dumps the inactive part of the transaction log without making a backup copy of it. After you use WITH TRUNCATE_ONLY, the changes recorded in the active part of the transaction log are erased. Follow the DUMP TRANSACTION with a DUMP DATABASE statement, or you will be unable to recover the database in the future by using the transaction logs.