Video Screencast Help

SQL Backup Job for truncate sql logs

Created: 08 Jan 2013 | 6 comments

Hi there,

I have a question, my backupjob should truncate teh sql log from the database. Should i use the sql option "log" or diffrent. I think right is the log option but i am not sure.

thank you

Comments 6 CommentsJump to latest comment

Kiran Bandi's picture

You should use Log method to have the logs truncated. Only the data contained in transaction logs will be backedup and logs will be truncated once done.

Lykantroph's picture

ok, so i have all two hours a sql backup job with the option diffrent, in the evening i have a seperate job with full and after this job is complete i have a backup job with log ?. T

hank you

Kiran Bandi's picture

I think it is opposite...

See the note present in the screenshot!

Lykantroph's picture

Ok, what i have read is the first incremental job must have the log option the second to truncate the log have the diffrent option.

lmosla's picture

Hi,  take a look at this document that explains the methods for backing up SQL databases.


1. Full    2. Daily Differential   3.after the Differential do a Incremental Log Backup

pkh's picture

SQL transaction logs are used to do point-in-time restores.  Normally, once you have done either a full or incremental backup, the transaction logs are of not much use.  There is no fixed interval whereby you need to truncate the logs, but you must truncate the logs.  Otherwise they will grow until your disk is full.

A database backup will not truncate the logs.  You must run a log backup job with the truncate log option to truncate the logs.

For me, I schedule a log backup after my full backup so that the logs are truncate after each full backup.  I don't do incremental database backups, but if I do, I would also schedule a log backup after each incremental backup.