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?

asked 14 Apr, 18:38

Sako's gravatar image

Sako
1.0k405595
accept rate: 25%

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.

(15 Apr, 09:50) Breck Carter

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...

(15 Apr, 10:15) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×82
×12

question asked: 14 Apr, 18:38

question was seen: 64 times

last updated: 15 Apr, 10:15