Availability for the Always-On Enterprise
Post Reply
cdlane
Enthusiast
Posts: 49
Liked: 3 times
Joined: Aug 09, 2015 5:48 pm
Full Name: Chris Lane
Contact:

SQL Logs - .VLB - Cloud Connect

Post by cdlane » Aug 12, 2016 10:44 am

Hi All,

I'm looking at turning on the Log Transaction backup as we currently just truncate the logs, not back them up.

Once backed up, are these .VLB's sent to the off-site storage too?

Best regards,

Chris

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

Re: SQL Logs - .VLB - Cloud Connect

Post by foggy » Aug 12, 2016 11:05 am

Hi Chris, currently transaction logs backup files are not processed by the backup copy jobs. However, if you mean direct backup jobs to remote repository, then yes, VLB files will be stored there along with the backups.

cdlane
Enthusiast
Posts: 49
Liked: 3 times
Joined: Aug 09, 2015 5:48 pm
Full Name: Chris Lane
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by cdlane » Aug 12, 2016 11:39 am

Hi Foggy,

Many thanks. I will switch it on and watch the magic!

The reason I asked the question was our remote repository account is quite full and I didn't want to tip it over the edge.

Best regards,

Chris

Cullan
Service Provider
Posts: 93
Liked: 13 times
Joined: May 21, 2014 8:47 am
Full Name: Cullan Simpson
Location: New Zealand
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by Cullan » Nov 14, 2016 1:10 am

foggy wrote:Hi Chris, currently transaction logs backup files are not processed by the backup copy jobs. However, if you mean direct backup jobs to remote repository, then yes, VLB files will be stored there along with the backups.
Hi Foggy,

Are there any plans to support VLB files with the backup copy jobs?

Thanks,
Cullan

Mike Resseler
Veeam Software
Posts: 4668
Liked: 498 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by Mike Resseler » Nov 14, 2016 6:41 am

Cullan,

I am not aware of the plans so I will leave that open for Foggy :-)

But I would like to know what your business case is for sending the log files over with a backup copy job. In most of designs, the first backup is the short term one (e.g. 7 days) and in that case log files are important. But the BCJ to a secondary repository or location is mostly for some longer period and therefore I have enough with the daily SQL backup.

How do you see this? (I always like to hear business reasons, requirements etc... for other designs... ;-))

Thanks
Mike

v.Eremin
Veeam Software
Posts: 15077
Liked: 1133 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by v.Eremin » Nov 14, 2016 10:20 am

Are there any plans to support VLB files with the backup copy jobs?
It's not included in 9.5. Further plans are yet to be determined. Thanks.

jmmarton
Veeam Software
Posts: 1207
Liked: 136 times
Joined: Nov 17, 2015 2:38 am
Full Name: Joe Marton
Location: Chicago, IL
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by jmmarton » Nov 14, 2016 7:02 pm

Could a file copy job be used to copy VLB files to another destination?

Joe

Cullan
Service Provider
Posts: 93
Liked: 13 times
Joined: May 21, 2014 8:47 am
Full Name: Cullan Simpson
Location: New Zealand
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by Cullan » Nov 14, 2016 7:12 pm

Mike Resseler wrote:Cullan,

But I would like to know what your business case is for sending the log files over with a backup copy job. In most of designs, the first backup is the short term one (e.g. 7 days) and in that case log files are important. But the BCJ to a secondary repository or location is mostly for some longer period and therefore I have enough with the daily SQL backup.

How do you see this? (I always like to hear business reasons, requirements etc... for other designs... ;-))
Hi Mike,

Sure. We actually keep the same retention in all of our sites (28 daily backup jobs) then we have backup copy jobs running the same retention offsite (28 daily) ie SiteA > SiteB, SiteA > Site C, SiteB > SiteA, SiteC > SiteA.

We could use something like SAN replication but that would increase our storage costs and also open up the failure domain, we are quite happy with the way the backup copy jobs work it's just that it would be nice to get the VLBs included in the copy jobs. We don't offer log backup via Veeam to our IaaS clients currently due to the fact we would need to copy the entire Backup Job Chain offsite to meet our onsite/offsite requirements.

Thanks,
Cullan

Cullan
Service Provider
Posts: 93
Liked: 13 times
Joined: May 21, 2014 8:47 am
Full Name: Cullan Simpson
Location: New Zealand
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by Cullan » Nov 14, 2016 7:14 pm

jmmarton wrote:Could a file copy job be used to copy VLB files to another destination?

Joe
Hi Joe,

As I understand it I would need to run a File copy on the entire backup chain as well as the VLB files. That is too much data to keep in sync.

-Cullan

v.Eremin
Veeam Software
Posts: 15077
Liked: 1133 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL Logs - .VLB - Cloud Connect

Post by v.Eremin » Nov 15, 2016 9:12 am

Could a file copy job be used to copy VLB files to another destination?
You could use a file copy job to copy .vlb files to another location. However, it would be useless action, as logs could be replayed on original restore points only, not on secondary synthesized ones. Thanks.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 22 guests