Comprehensive data protection for all workloads
Regnor
Service Provider
Posts: 376
Liked: 79 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: 5623
Liked: 547 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
Service Provider
Posts: 376
Liked: 79 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: 11754
Liked: 1029 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
Service Provider
Posts: 376
Liked: 79 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
Expert
Posts: 216
Liked: 22 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: 17834
Liked: 1661 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
Expert
Posts: 161
Liked: 13 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: 11754
Liked: 1029 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: 30
Liked: 1 time
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: 19433
Liked: 1763 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
Novice
Posts: 6
Liked: 3 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: 19433
Liked: 1763 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
Expert
Posts: 161
Liked: 13 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
Expert
Posts: 161
Liked: 13 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: 19433
Liked: 1763 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
Expert
Posts: 161
Liked: 13 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: 19433
Liked: 1763 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.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot] and 23 guests