-
- Enthusiast
- Posts: 37
- Liked: 7 times
- Joined: Nov 23, 2015 4:47 pm
- Full Name: VanillaMastermind
- Contact:
SQL Server - Transaction log - exclude certain time?
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...
-
- Veeam Software
- Posts: 21144
- Liked: 2143 times
- Joined: Jul 11, 2011 10:22 am
- Full Name: Alexander Fogelson
- Contact:
Re: SQL Server - Transaction log - exclude certain time?
I don't see any way except temporary disabling the job via script.
-
- Novice
- Posts: 7
- Liked: 1 time
- Joined: Dec 30, 2015 2:45 pm
- Full Name: Marco Teijido
- Contact:
Re: SQL Server - Transaction log - exclude certain time?
Hi, and how do I disable a job with script?
-
- VP, Product Management
- Posts: 27451
- Liked: 2822 times
- Joined: Mar 30, 2009 9:13 am
- Full Name: Vitaliy Safarov
- Contact:
Re: SQL Server - Transaction log - exclude certain time?
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
-
- 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?
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.
-
- Chief Product Officer
- Posts: 31905
- Liked: 7402 times
- Joined: Jan 01, 2006 1:01 am
- Location: Baar, Switzerland
- Contact:
Re: SQL Server - Transaction log - exclude certain time?
This topic is already a feature request, nothing else needs to be done on your part
Who is online
Users browsing this forum: Bing [Bot], Semrush [Bot] and 47 guests