Previous Topic: Truncating Transaction Log GuidelinesNext Topic: When to Use DUMP TRANSACTION Statement and WITH TRUNCATE ONLY Class

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

Back Up Database Before Truncating Logs

Back up the entire database before truncating transaction logs. All three of these options truncate the log for the specified database, however the options do not make a backup copy.

Note: DUMP DATABASE backs up the database and the transaction log but does not remove the inactive portion of the transaction log.