Backup Copy & SQL Tran Logs

VMware specific discussions

Backup Copy & SQL Tran Logs

Veeam Logoby wgrixti » Wed Jan 13, 2016 11:06 pm

Hi,

I am running V8 Patch 3.

In the GUI it does not look like the "Backup Copy" copies over the Transaction Logs associated with a Backup Job that uses Application-Aware processing to Backup SQL logs periodically.
If I look at the Disk view under Backups under the Backup Job I can see the VM and the Tran Logs however under the Backup Copy job I can see the VM but there are no Tran Logs.
Are the logs actually there? Is this normal?

Thanks

Wayne
wgrixti
Influencer
 
Posts: 11
Liked: never
Joined: Fri Oct 30, 2015 1:02 am
Full Name: Wayne Grixti

Re: Backup Copy & SQL Tran Logs

Veeam Logoby Gostev » Thu Jan 14, 2016 2:20 am

Hi, Backup Copy jobs do not support shipping transaction log backups. But, we are considering this feature. Thanks!
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Backup Copy & SQL Tran Logs

Veeam Logoby wgrixti » Thu Jan 14, 2016 2:48 am

Thank you for the quick reply.

Where are the actual Tran logs stored on the backup repository? Can I set up a copy process to move them to a different server?
wgrixti
Influencer
 
Posts: 11
Liked: never
Joined: Fri Oct 30, 2015 1:02 am
Full Name: Wayne Grixti

Re: Backup Copy & SQL Tran Logs

Veeam Logoby alexander sh » Thu Jan 14, 2016 10:07 am

Hi wgrixti,
the transaction logs are stored in the same backup job folder along with the regular backup files. They are stored in files with .vlb extension.
These are container files which store multiple tran log backup files each. You could in theory set up a copy process to copy them somewhere, however you wouldn't be able to utilize these files for SQL point in time restore unless you also have the image-level backup files from the original backup job itself - meaning you can't apply these log files to backup files generated by a backup copy job.
alexander sh
Veeam Software
 
Posts: 23
Liked: 16 times
Joined: Thu Dec 13, 2012 8:52 am
Full Name: Alexander Shelemin

Re: Backup Copy & SQL Tran Logs

Veeam Logoby wgrixti » Thu Jan 14, 2016 10:43 pm

Thank you for clarifying this Alexander.

It would be nice to see this as a new feature going forward to have Tran Logs copied across and associated with the VM during a Backup Copy process.
wgrixti
Influencer
 
Posts: 11
Liked: never
Joined: Fri Oct 30, 2015 1:02 am
Full Name: Wayne Grixti


Return to VMware vSphere



Who is online

Users browsing this forum: Google [Bot], rjlewis and 31 guests