Truncate Transaction Logs During Backup
To decrease the size of a transaction log, you can choose to truncate the transaction log when you back it up. When the agent backs up a transaction log without truncating it, the agent backs up the log from the last successfully executed log backup to the current end of the log. The backup includes both the active and inactive portions of the log file. If you choose to truncate the log during backup, the agent removes the inactive portion of the log and truncates the log to the beginning of its active portion, the part that contains the oldest open transaction.
|
Copyright © 2016
|
|