Understanding Log Truncation Options
The different backup log truncation options are often overlooked by new DBAs. Quite frequently new DBAs do not know the options exist, or if they do know about the options, they don't know how or when to use them. The following sections explain each of the options in detail and when to use them.
TRUNCATE_ONLY
The TRUNCATE_ONLY option removes the inactive part of the transaction log (truncates) without backing up (copying) the log to a backup device. You do not have to specify a backup device when using TRUNCATE_ONLY because the log is not copied. For example, the syntax to back up the master database transaction log with the TRUNCATE_ONLY option is as follows:
Backup Log master WITH TRUNCATE_ONLY
CAUTION ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
