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...
-
- Veeam Legend
- Posts: 231
- Liked: 37 times
- Joined: Nov 04, 2009 2:08 pm
- Contact:
-
- Veeam Software
- Posts: 3626
- Liked: 608 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: SQL log-shipping - window of operation
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!
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!
-
- Veeam Legend
- Posts: 231
- Liked: 37 times
- Joined: Nov 04, 2009 2:08 pm
- Contact:
Re: SQL log-shipping - window of operation
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
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
-
- Veeam Software
- Posts: 3626
- Liked: 608 times
- Joined: Aug 28, 2013 8:23 am
- Full Name: Petr Makarov
- Location: Prague, Czech Republic
- Contact:
Re: SQL log-shipping - window of operation
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!
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!
Who is online
Users browsing this forum: Majestic-12 [Bot] and 40 guests