|
The BACKUP DATABASE Statement is equivalent to the DBBACKUP utilty, but I am wondering how can I enforce the BACKUP DATABASE Statement to delete the unneeded transaction log files (after considering the delete_old_logs option, and also considering the logs required by DBREMOTE/DBMLSYNC). In the documentation I can see the option TRANSACTION LOG RENAME as backup-option of the BACKUP DATABASE Statement, but I can't see any option for deleting the unneeded transaction log files! Any ideas? |
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 14 Apr '20, 18:38
question was seen: 719 times
last updated: 15 Apr '20, 10:15
TRANSACTION LOG TRUNCATE... but be careful. Many an otherwise good day has been ruined by BACKUP statements which work differently from the (supposed) equivalent dbbackup commands.
Why do you have "unneeded transaction log files"?
What is your backup strategy w.r.t. transaction logs, do you always rename them? It may be easier to let the log grow until the next full backup if size is no problem... - and to backup to rotating directories...