Comprehensive data protection for all workloads
Regnor
Veeam Software
Posts: 934
Liked: 287 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by Regnor »

@Anton: Will this only this also be implemented for backup to tape jobs?
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by PTide »

Hi,

No, only for backup copy job for now.

Thanks!
Regnor
Veeam Software
Posts: 934
Liked: 287 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by Regnor »

Then please count that as a feature request for Logshipping to tape :)
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by Dima P. »

Regnor,

May I ask if you are plan to store the transaction log backup for archive purposes (long term backup) or that's going to be secondary copy to tape for the short term backup? Thank you in advance!
Regnor
Veeam Software
Posts: 934
Liked: 287 times
Joined: Jan 31, 2011 11:17 am
Full Name: Max
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by Regnor »

Mainly for short term retention to ensure that the logs are always on 2 different backup media.
jonboy
Novice
Posts: 5
Liked: never
Joined: Jan 23, 2015 12:33 pm
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by jonboy »

Another request for Veeam SQL Transaction Log Backups to be included in Veeam Backup Copy Job to be added ASAP, please.
FrancWest
Veteran
Posts: 488
Liked: 93 times
Joined: Sep 17, 2017 3:20 am
Full Name: Franc
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by FrancWest »

any update on this feature? In December Anton wrote it was almost ready.
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by veremin »

Anton wrote that most of the engine work had been done by that time and that we were trying to find a window to test the feature properly and release it afterwards.

We are yet to find this window (most likely, we're talking about next major release, but as always plans are subject to change).

Thanks!
sandsturm
Veteran
Posts: 278
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by sandsturm »

any news, if this requested feature is included in the upcoming version 10 of VBR?

thx,
sandsturm
Dima P.
Product Manager
Posts: 14396
Liked: 1568 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by Dima P. »

Ability to perform backup copy for transaction log is planned for the upcoming major version. Thanks!
mbroaders
Service Provider
Posts: 120
Liked: 8 times
Joined: May 15, 2012 9:06 am
Full Name: Martin Broaders
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by mbroaders »

That's great news. Do you know if it will be include on initial release of v10 or will it come later?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by foggy »

Good chances it will be a part of v10.
kaffeine
Enthusiast
Posts: 32
Liked: 11 times
Joined: Jun 04, 2018 8:03 am
Full Name: Espresso Doppio
Location: Austria
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by kaffeine »

Now that the release of the v10 is approaching, could you tell us if this feature is indeed coming?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by foggy » 2 people like this post

Yes, v10 will provide the ability to copy transaction logs along with backups.
sandsturm
Veteran
Posts: 278
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by sandsturm »

Do you mean, it´s possible to create a backup copy job, and with this backup copy job database backups and according transactionlog backups are processed and copied to a secondary site with this job?

thx
sandsturm
sandsturm
Veteran
Posts: 278
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by sandsturm »

plz ignore my question, I found it :-)
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by foggy »

Hopefully you've found it in the correct place - backup copy in Immediate mode is capable of transaction logs processing.
sandsturm
Veteran
Posts: 278
Liked: 23 times
Joined: Mar 23, 2015 8:30 am
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by sandsturm » 1 person likes this post

yes, we configured Immediate mode with the transaction log processing feature. A long awaited feature...
thanks a lot for this one, this will help us to be compliant with our policies
SQLPug
Lurker
Posts: 2
Liked: never
Joined: Sep 14, 2020 3:05 pm
Full Name: Paul Ingham
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by SQLPug »

Hi, Im a SQL DBA new to Veeam. Our sysadmins have set up server replication with a nightly server level backup and sql translogs backups via Veeam. They are under the impression that they can restore to the server level backup and then apply the SQL translogs which from my back ground working with SQL Native backups does not sound possible, I would of though you also needed a Veeam full sql backup daily also?
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by foggy »

Hi Paul, that's correct, you need a SQL Server backup created by Veeam B&R to replay the logs. But since they do transaction logs backup with Veeam B&R, then they also have SQL backups created by Veeam B&R, as transaction logs cannot be backed up separately.
dimaslan
Service Provider
Posts: 99
Liked: 9 times
Joined: Jul 01, 2017 8:02 pm
Full Name: Dimitris Aslanidis
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by dimaslan »

Hi,

Came across this topic while searching for something else but it's really interesting. Since it's also mentioning replication though, say we need to do daily backups for a SQL server, hourly log truncation and copy job, but also replication to a DR site 2-3 times per day.
If the replication job does log truncation too since Application Aware will be enabled, won't that have impact on the hourly log backups? Won't it cause issues?
FrancWest
Veteran
Posts: 488
Liked: 93 times
Joined: Sep 17, 2017 3:20 am
Full Name: Franc
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by FrancWest »

Hi,

when you select 'copy only' for transaction log backups under application aware processing, no log truncation is being performed.

You can also choose to create the replica's from backups. This prevent snapshots being taken and committed on production VMs at the start and end of the replication and thus has no impact on the live VM.
PetrM
Veeam Software
Posts: 3229
Liked: 519 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by PetrM »

Hello,

Just a small correction that there is no Copy-only mode for the replication job but anyway it would be best to run the replication from backup and delegate log truncation to the primary backup job.

UPDATE 02/08/2023: The Copy-only mode is available for the replication job, see this link.

Thanks!
FrancWest
Veteran
Posts: 488
Liked: 93 times
Joined: Sep 17, 2017 3:20 am
Full Name: Franc
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by FrancWest » 1 person likes this post

Uhm, I’m able to select copy only when creating a replication job, running V11.

Image
PetrM
Veeam Software
Posts: 3229
Liked: 519 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by PetrM »

Hi Franc,

You're absolutely right, I misclicked yesterday because was in a hurry. My sincere apologies about the misleading information, I updated my previous post. Anyway, the suggestion to use replication from backup is still valid, at least because it allows us to reduce load on the production environment.

Thanks!
FrancWest
Veteran
Posts: 488
Liked: 93 times
Joined: Sep 17, 2017 3:20 am
Full Name: Franc
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by FrancWest » 1 person likes this post

No problem! Indeed, replicating from backup is the preferred way to go.
dimaslan
Service Provider
Posts: 99
Liked: 9 times
Joined: Jul 01, 2017 8:02 pm
Full Name: Dimitris Aslanidis
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by dimaslan »

What is replication from backup? Instead of doing replication from VMs? By Veeam best practice the replication should be done on a Veeam server at the DR site. Not sure how that Veeam server at the DR location would be able to see the production Veeam server backups.
FrancWest
Veteran
Posts: 488
Liked: 93 times
Joined: Sep 17, 2017 3:20 am
Full Name: Franc
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by FrancWest »

I'm not sure what you mean. We are replicating from our Veeam server at our main site to vCenter in the DR site. Our backup copies are also located at the DR site, so that's where Veeam is taking it's backups from (through the backup proxy at the DR site). In the replication job settings you are able to select a source for the replication. Choose the backup repository at the DR site there (if you have any). You can also choose a repository at the main site, but that would mean all data is being transferred over the WAN connection instead of being local at the DR site.

https://helpcenter.veeam.com/docs/backu ... ml?ver=120
PetrM
Veeam Software
Posts: 3229
Liked: 519 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Transaction Logs in Backup Copy or Replica

Post by PetrM »

Hello,

In general, it is possible to deploy Veeam B&R on the DR site to orchestrate all tasks including the primary backups on the production site, backup copies, and replications from the production site to the DR one.

Thanks!
Post Reply

Who is online

Users browsing this forum: Semrush [Bot], ThomasIkoula and 139 guests