Backup of enterprise applications (Microsoft stack, IBM Db2, MongoDB, Oracle, PostgreSQL, SAP)
Post Reply
srlarsen
Influencer
Posts: 11
Liked: 1 time
Joined: Jun 07, 2022 5:30 pm
Full Name: Stephen Larsen
Contact:

Plug-in for Microsoft SQL Server and scale out repos 24hr rule

Post by srlarsen »

https://helpcenter.veeam.com/docs/backu ... acity-tier

"IMPORTANT
With both the Copy and Move policies, Veeam Backup & Replication copies and moves to the capacity tier only non-active backup files created more than 24 hours ago, which match the capacity tier configuration parameters. For details, see Backup Chain. To learn more about the capacity tier configuration, see Add Capacity Tier in the Veeam Backup & Replication User Guide."

I understand the reasoning behind this with the "Move" policy but I'm a little confused as to why we can't have the immediate copy. This is very frustrating. There are already so many restrictions on storing SQL plug in backups that we have had to work around and this one just hit us in the face. We are trying to keep all our immutable copies in Wasabi. We back up to local disk and then scale out to Wasabi. We use scale out repositories for pretty much everything and on our "normal" VM backups, as soon as it backs up we get a copy in the capacity tier. At the time of backup or very soon after, we have our production system, immutable copy, and third location copy all done. With the SQL plug-in, we want the same functionality. It isn't really "safe" these days to wait 24hrs before you have your data to an offsite location and have an immutable copy. I realize the article states that you can contact support if you want to use a hardened repository and can change the 24hr timeframe but that doesn't get the data offsite and then we have immutable copies in different locations. We don't like not having to wait to have an immutable and offsite copy, it feels like we're running with scissors. Is this going to be changed/improved?
tina.cornelison
Novice
Posts: 8
Liked: 1 time
Joined: Mar 31, 2022 7:47 pm
Full Name: Tina Cornelison
Contact:

Re: Plug-in for Microsoft SQL Server and scale out repos 24hr rule

Post by tina.cornelison »

My thought on using the two options together would be this..
1) offload immediately as it states (if you aren't going to then you need to specify)
2) move X days - recognizes the offload has occurred and deletes the local copy OR if for some reason there was a failure in the immediate offload it would then ensure the offload occurred.
Andreas Neufert
VP, Product Management
Posts: 7162
Liked: 1535 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: Plug-in for Microsoft SQL Server and scale out repos 24hr rule

Post by Andreas Neufert »

Hi Stephen,
I think there is a reg key for changing this to a more frequent value. Let me check please and report back to you end of the week as there are some bank holidays here.
PetrM
Veeam Software
Posts: 3705
Liked: 621 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Plug-in for Microsoft SQL Server and scale out repos 24hr rule

Post by PetrM »

Hello,

Here is the registry key that decreases the period of time to use the same backup file on write, thus increases the offload frequency and ensures faster immutability setting:
Value: SQLPluginStgWriteMinutes
Path: HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication
Type: reg_dword

Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests