Best Practices for SQL Trans log backups - replicate offsite

Availability for the Always-On Enterprise

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

Veeam Logoby PTide » Wed Jun 08, 2016 2:56 pm

Will 9.5 allow backup copy of DB logs?
No, unfortunately, it won't.
PTide
Veeam Software
 
Posts: 2846
Liked: 231 times
Joined: Tue May 19, 2015 1:46 pm

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

Veeam Logoby pkelly_sts » Wed 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!!!]
pkelly_sts
Expert
 
Posts: 467
Liked: 50 times
Joined: Thu Jun 13, 2013 10:08 am
Full Name: Paul Kelly

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

Veeam Logoby aspen432 » Wed 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.
aspen432
Novice
 
Posts: 3
Liked: never
Joined: Tue Dec 23, 2014 2:13 pm
Full Name: Max Speyer

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

Veeam Logoby justmehere » Mon Feb 27, 2017 10:17 pm

I agree with everyone else here.

First the "File Copy" does not work because it will also copy the files the "Backup Copy" is supposed to be taking care of.
It would be simple to do a "File Copy" if I could just put my Logs backup into a different directory. The "Backup Copy" was configured by the parent job just like the LOG file copies.

Since "Backup Copy" is supposed to make my "oh crap the server room caught on fire"-second site backup a good idea, I am lost why getting the transaction logs onto the second site is not important.

Have I missed something?
justmehere
Lurker
 
Posts: 1
Liked: never
Joined: Mon Feb 27, 2017 10:10 pm

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

Veeam Logoby mkretzer » Tue Feb 28, 2017 8:05 pm

I also hope this gets "fixed" in 10.0!
mkretzer
Expert
 
Posts: 236
Liked: 54 times
Joined: Thu Dec 17, 2015 7:17 am

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

Veeam Logoby mrapp » Thu 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.
mrapp
Lurker
 
Posts: 1
Liked: never
Joined: Thu Mar 09, 2017 2:03 pm
Full Name: Mitchell Rapp

Previous

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: NCCUIT, ss-12 and 27 guests