Availability for the Always-On Enterprise
Post Reply
Posts: 6
Liked: never
Joined: Feb 10, 2017 10:07 am

'SQL Log Backup' and 'Backup window'

Post by xmzmc » Jul 14, 2017 3:07 pm


I couldn't find an answer through search so I'm sorry if this has been asked before. When backing up a Windows Server with MS SQL server and Application aware processing enabled, how does Schedule > Backup window affect the SQL Log Backup. Does it ignore the window or obey it?

Whe have a job that backups a VM and also its SQL log with an interval of 240 mins through AWP. The window of this job restricts it to run during daytime but the SQL log job is basically always in running state. The end result of both jobs is always good, but looking at the timestamps it seems that the SQL log job is ignoring Backup window rules. Is this correct?

Veeam Software
Posts: 6082
Liked: 524 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague

Re: 'SQL Log Backup' and 'Backup window'

Post by Shestakov » Jul 15, 2017 9:27 pm

Hi, that`s correct. Backup window does not propagate to SQL logs backup.

Posts: 2
Liked: 1 time
Joined: Jul 12, 2015 7:40 am
Full Name: Frank Dalgaard

Re: 'SQL Log Backup' and 'Backup window'

Post by FrankD » Dec 04, 2017 12:12 pm

Hi. Shestakov

Could you pleace take this as a +1 for a feature request to be able to controlle when to take SQL log backup.

Case where this is needed:
Backup of a SQL server which is backend for at webshop, orders are coming in i from 06:00 to 22:00 so here the customer want 15min LOG backup, but at night they load price updates at 02:00 and do database maintance, which changes alot in the database and gernerates ALOT of log data which we don´t need backup of and will sometime give errors in the backup rapport because its unable to finish the LOG backup in the 15min time slot.

Suggestion would be to be able to set at separate time window to do the log backup or be able to say that log backup should run for x hours after VM backup, example: backup at 04:00 and log backup for 18hours in x interval, pause LOG backup until next full.

in this way we will not have to run log backup of nightly batch changes.

Frank Dalgaard

Veeam Software
Posts: 17087
Liked: 1396 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: 'SQL Log Backup' and 'Backup window'

Post by foggy » Dec 04, 2017 3:57 pm

Hi Frank, your request is accepted. Meanwhile, please review this thread, should help in case you decide to workaround by temporarily enabling/disabling the logs backup via script.

Post Reply

Who is online

Users browsing this forum: No registered users and 33 guests