Comprehensive data protection for all workloads
Post Reply
mdiver
Veeam Legend
Posts: 223
Liked: 37 times
Joined: Nov 04, 2009 2:08 pm
Contact:

SQL log-shipping - window of operation

Post by mdiver »

Consider the need to have log-shipping to be only allowed in certain periods of time.

My first idea was the backup window setting within the main jobs schedule and if it also applies to the child process for log-shipping:
https://helpcenter.veeam.com/docs/backu ... ml?ver=120
Unfortunately it doesn't.

Are there any other ways besides disabling and re-enabling the main job with a scheduled script?
Could be considered a feature request if not... :D
PetrM
Veeam Software
Posts: 3612
Liked: 604 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: SQL log-shipping - window of operation

Post by PetrM »

Hello,

The transaction log backup is quite an important operation that must be performed on a regular schedule to prevent the transaction log from filling. Moreover, usually log backups do not process too much data and I doubt that they can overload the infrastructure, could you please clarify why would you like to have such a backup window for log backups?

Thanks!
mdiver
Veeam Legend
Posts: 223
Liked: 37 times
Joined: Nov 04, 2009 2:08 pm
Contact:

Re: SQL log-shipping - window of operation

Post by mdiver » 1 person likes this post

I was confronted with the request by larger customers twice already.
SQL databases undergo large-scale rearrangements and/or mass-fills on certain days. They have to make sure no operation interferes. Also internal SLAs apply.
Log-truncation is said to be not necessary in these periods.

We think about disabling and enabling the job on a script base. Of course this is prone to errors. If the script fails for some reason, you silently loose your backup.

Thanks, Mike
PetrM
Veeam Software
Posts: 3612
Liked: 604 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: SQL log-shipping - window of operation

Post by PetrM »

Hello,

Many thanks for clarifying. The request is noted but we'll define its priority later depending on the number of similar requests and its potential value.

Thanks!
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 88 guests