Comprehensive data protection for all workloads
Post Reply
VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

SQL Server - Transaction log - exclude certain time?

Post by VanillaMastermind » Apr 13, 2016 3:53 pm 2 people like this post

Is there any way to exclude certain timeframes for SQL Server transaction log backups? For example, back up the logs every 15 minutes, but not from 1am-3am for integrity checks, data loads, etc...

foggy
Veeam Software
Posts: 18458
Liked: 1589 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: SQL Server - Transaction log - exclude certain time?

Post by foggy » Apr 14, 2016 4:49 pm

I don't see any way except temporary disabling the job via script.

Marco.Teijido
Novice
Posts: 6
Liked: 1 time
Joined: Dec 30, 2015 2:45 pm
Full Name: Marco Teijido
Contact:

Re: SQL Server - Transaction log - exclude certain time?

Post by Marco.Teijido » Apr 19, 2016 1:03 pm

Hi, and how do I disable a job with script?

Vitaliy S.
Product Manager
Posts: 23230
Liked: 1611 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Server - Transaction log - exclude certain time?

Post by Vitaliy S. » Apr 19, 2016 2:28 pm

You try one of these script examples to do that for SQL Server transaction log backup job > Auto-stop job schedule and Code to enable/disable Backup Jobs

VanillaMastermind
Enthusiast
Posts: 37
Liked: 7 times
Joined: Nov 23, 2015 4:47 pm
Full Name: VanillaMastermind
Contact:

Re: SQL Server - Transaction log - exclude certain time?

Post by VanillaMastermind » Apr 19, 2016 6:07 pm

How do I get this turned into a feature request? This seems like something a lot of people would be interested in. It would be nice to have this configurable within Veeam, instead of managing separate settings through PowerShell.

Gostev
SVP, Product Management
Posts: 25145
Liked: 3698 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL Server - Transaction log - exclude certain time?

Post by Gostev » Apr 20, 2016 12:11 am

This topic is already a feature request, nothing else needs to be done on your part :D

Post Reply

Who is online

Users browsing this forum: EdgarRicharte, Gostev and 75 guests