Availability for the Always-On Enterprise
PTide
Veeam Software
Posts: 4246
Liked: 349 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by PTide » Jun 08, 2016 2:56 pm

Will 9.5 allow backup copy of DB logs?
No, unfortunately, it won't.

pkelly_sts
Expert
Posts: 550
Liked: 58 times
Joined: Jun 13, 2013 10:08 am
Full Name: Paul Kelly
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by pkelly_sts » Nov 23, 2016 10:48 am

Ouch!
Having literally just this weekend completed migrating away from a SQL Cluster to a standalone SQL primarily to bring the SQL server into the scope of Veeam backups (simply because at the end of the day, an RTO of up to 15 minutes rather than seconds was actually sufficient for their needs), and getting ready to show them (the users) how amazing the restore options are as well as the far improved off-site copies will be (in comparison to their daily full DB backups which then went to tape which then went off-site some time the next day), I'm rather shocked to discover that off-site copies of TL backups can't (EASILY) be brought into scope as well without a load of workarounds!

:-/
[New Sig: PLEASE get GFS tape support for incrementals!!!]

aspen432
Novice
Posts: 3
Liked: never
Joined: Dec 23, 2014 2:13 pm
Full Name: Max Speyer
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by aspen432 » Dec 21, 2016 11:00 pm

Am just stumbling upon this thread and have to agree that this is a real bummer. Would really be a nice feature to have for us so I'm hoping it's under serious consideration for a future release.

mkretzer
Expert
Posts: 399
Liked: 79 times
Joined: Dec 17, 2015 7:17 am
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by mkretzer » Feb 28, 2017 8:05 pm

I also hope this gets "fixed" in 10.0!

mrapp
Lurker
Posts: 1
Liked: never
Joined: Mar 09, 2017 2:03 pm
Full Name: Mitchell Rapp
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by mrapp » Mar 09, 2017 2:06 pm

Is this T-Log restriction only for replicated SQL backup copies or all as SQL PIT log-based restores seem to work from the original copy quite well.

kubimike
Expert
Posts: 312
Liked: 37 times
Joined: Feb 03, 2017 2:34 pm
Full Name: MikeO
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by kubimike » Jun 20, 2017 8:05 pm

+1 this doesn't make 3-2-1 easy for SQL!

Samba222
Influencer
Posts: 14
Liked: 2 times
Joined: Jan 18, 2017 11:54 am
Full Name: Ronald
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by Samba222 » Oct 20, 2017 1:42 pm

oh yes, we also have the wish that transaction logs are also included (or the possibility) in Backup to Tape Job - this would be a really nice feature :-)

jvlad
Lurker
Posts: 1
Liked: never
Joined: Jul 10, 2018 6:20 pm
Full Name: Jason
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by jvlad » Jul 10, 2018 6:36 pm

The discovery of this transaction log backup-copy shortcoming has been an unsettling find of Veeam B&R 9.5. There should be a warning popup at a minimum when you setup the TL backups so atleast backup administrators are aware of this limitation if a BackupCopy will be put in place.
Seriously the DB Server backup is 95% there but Veeam decided to release the product without a viable built in and supported option to replay logs at a DR site.
Feature consistence in this product seems to be lacking. Found another post where someone stated this issue should be considered more of a bug than a feature request and frankly I agree with him and Veeam development should be all over it. Its now July 2018 and still no option for this and the earliest post I found on this was Jan 2015, and yet this feature is still in the works. Ohhh not good.

https://forums.veeam.com/veeam-backup-r ... 25349.html

Love the product but just a bit bummed out I guess.

nrexpress
Service Provider
Posts: 3
Liked: never
Joined: Mar 29, 2018 6:27 pm
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by nrexpress » Jul 12, 2018 6:59 pm

I also echo that the lack of a transaction log backup copy to be a significant issue. The customers that I know that want to use Veeam have multiple reasons for doing so -- but generally because 1) they need a DR solution, not just a backup solution and 2) they need to backup systems, not just files, and therefore are generally looking to backup SQL. These same customers generally have at least one SQL database that are too big to send both full backups and full replicas over the same WAN link.

Is there an update on where we are on this feature request?

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

Re: Best Practices for SQL Trans log backups - replicate off

Post by foggy » Jul 13, 2018 12:21 pm 1 person likes this post

It is on our short-term list.

alesovodvojce
Enthusiast
Posts: 29
Liked: 2 times
Joined: Nov 29, 2016 10:09 pm
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by alesovodvojce » Jul 13, 2018 8:45 pm

We have assured the board that the critical system is having 15minute RPO and today after accidently finding out that our Backup copy job seems to ignore that log transfers I ended in this forum thread. It is embarassing that the backup is not doing something really expected.
Thanks for looking into that!

nrexpress
Service Provider
Posts: 3
Liked: never
Joined: Mar 29, 2018 6:27 pm
Contact:

Re: Best Practices for SQL Trans log backups - replicate off

Post by nrexpress » Aug 17, 2018 10:06 pm

Is there an update on the feature request for the SQL transaction log being sent over backup copy job?

Thanks.

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

Re: Best Practices for SQL Trans log backups - replicate off

Post by foggy » Aug 20, 2018 12:53 pm

No changes since my last post month ago.

Post Reply

Who is online

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