SQL Logs - .VLB - Cloud Connect

Availability for the Always-On Enterprise

SQL Logs - .VLB - Cloud Connect

Veeam Logoby cdlane » Fri 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
cdlane
Enthusiast
 
Posts: 45
Liked: 3 times
Joined: Sun Aug 09, 2015 5:48 pm
Full Name: Chris Lane

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby foggy » Fri 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.
foggy
Veeam Software
 
Posts: 15087
Liked: 1110 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby cdlane » Fri 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
cdlane
Enthusiast
 
Posts: 45
Liked: 3 times
Joined: Sun Aug 09, 2015 5:48 pm
Full Name: Chris Lane

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby Cullan » Mon 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
Cullan
Service Provider
 
Posts: 70
Liked: 10 times
Joined: Wed May 21, 2014 8:47 am
Location: New Zealand
Full Name: Cullan Simpson

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby Mike Resseler » Mon 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
Mike Resseler
Veeam Software
 
Posts: 3345
Liked: 380 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby v.Eremin » Mon 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.
v.Eremin
Veeam Software
 
Posts: 13558
Liked: 1006 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby jmmarton » Mon Nov 14, 2016 7:02 pm

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

Joe
jmmarton
Veeam Software
 
Posts: 892
Liked: 95 times
Joined: Tue Nov 17, 2015 2:38 am
Location: Chicago, IL
Full Name: Joe Marton

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby Cullan » Mon 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: 70
Liked: 10 times
Joined: Wed May 21, 2014 8:47 am
Location: New Zealand
Full Name: Cullan Simpson

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby Cullan » Mon 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
Cullan
Service Provider
 
Posts: 70
Liked: 10 times
Joined: Wed May 21, 2014 8:47 am
Location: New Zealand
Full Name: Cullan Simpson

Re: SQL Logs - .VLB - Cloud Connect

Veeam Logoby v.Eremin » Tue 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.
v.Eremin
Veeam Software
 
Posts: 13558
Liked: 1006 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: No registered users and 49 guests