Transaction Logs in Backup Copy or Replica

Availability for the Always-On Enterprise

Transaction Logs in Backup Copy or Replica

Veeam Logoby akrimmer » Mon Jan 05, 2015 7:03 pm 3 people like this post

I would like to see a method to copy SQL transaction logs to a DR site either using a replica job or backup copy job. Currently this is not available since neither of them are application aware.

The goal is to have local SQL backups with 30 minute T-Log backups, daily SQL replica jobs to our DR site, and some method to copy the T-Logs to the DR site to get the replica current in the event of a failover. Currently, if we had to failover to our replica, we could be failing over the last nightly replica that ran and could be anywhere from 1-23 hours behind in our SQL data. We need way to be able to replay those T-Logs at the DR site to get the replica current.

Thanks,
akrimmer
Lurker
 
Posts: 2
Liked: 3 times
Joined: Mon Nov 10, 2014 2:30 pm

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby Dima P. » Mon Jan 05, 2015 9:02 pm

Hello and welcome to Veeam forums,
Thank you for detailed explanation – we will look into this.
Dima P.
Veeam Software
 
Posts: 5745
Liked: 407 times
Joined: Mon Feb 04, 2013 2:07 pm
Location: SPb
Full Name: Dmitry Popov

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby Greg.Bean-DeFlumer » Tue Jan 06, 2015 12:00 am

Support case #715622
Greg.Bean-DeFlumer
Veeam ProPartner
 
Posts: 15
Liked: 4 times
Joined: Thu Sep 18, 2014 8:26 pm
Full Name: Gregory Bean-DeFlumer

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby rp.TICnine » Wed Feb 11, 2015 7:15 pm

Any update about this request?

Thanks in advance!
rp.TICnine
Lurker
 
Posts: 2
Liked: never
Joined: Wed Feb 11, 2015 7:04 pm
Full Name: Rafa @ TICnine

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby foggy » Thu Feb 12, 2015 4:01 pm

What kind of update are you looking for? If you're interested in this functionality, then your voice is counted. We collect all the feedback but prioritize features based on the number of requests and value to the product.
foggy
Veeam Software
 
Posts: 14086
Liked: 1027 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby rp.TICnine » Thu Feb 12, 2015 9:55 pm

Sure! I'm really interested in this feature! Count on me for the request.
rp.TICnine
Lurker
 
Posts: 2
Liked: never
Joined: Wed Feb 11, 2015 7:04 pm
Full Name: Rafa @ TICnine

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby OmiFreak » Mon Feb 16, 2015 7:54 am

We would need this function as well. SQL log backup just in on location is not sufficient.
OmiFreak
Influencer
 
Posts: 13
Liked: 2 times
Joined: Tue Apr 26, 2011 4:11 pm
Full Name: Bernd Flatz

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby PinnaclePatron » Sun Apr 05, 2015 2:07 am

I would also like to see a method of updating the remote SQL replica with transaction log backups.
PinnaclePatron
Lurker
 
Posts: 1
Liked: never
Joined: Sun Apr 05, 2015 2:01 am
Full Name: Kevin Bickerton

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby ingvargo » Wed Apr 08, 2015 2:43 pm

I am also intererested to have this function in copy jobs.
ingvargo
Novice
 
Posts: 7
Liked: never
Joined: Mon Jul 29, 2013 4:41 pm

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby jim3cantos » Wed Apr 15, 2015 6:49 am

OmiFreak wrote:We would need this function as well. SQL log backup just in on location is not sufficient.


+1
jim3cantos
Enthusiast
 
Posts: 38
Liked: 5 times
Joined: Tue Jan 08, 2013 6:14 pm
Location: Madrid, Spain
Full Name: José Ignacio Martín Jiménez

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby jim3cantos » Fri Apr 17, 2015 7:40 am

PinnaclePatron wrote:I would also like to see a method of updating the remote SQL replica with transaction log backups.

supposing that transaction logs are accessible from replication site:

1) In the event of a failover of SQL server to the replica, veeam explorer will be able to apply logs from original SQL server to replica without problems? I suppose yes, but better to confirm.

2) any "easy" way to test point 1? Could be with a surebackup job with replicas of Veeam server, SQL server and SQL logs repository in the app. group?
jim3cantos
Enthusiast
 
Posts: 38
Liked: 5 times
Joined: Tue Jan 08, 2013 6:14 pm
Location: Madrid, Spain
Full Name: José Ignacio Martín Jiménez

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby foggy » Tue Apr 28, 2015 1:22 pm

Currently logs grabbed during the backup can be replayed on the database from their corresponding parent VM backup only. No way to apply them to replica VM.
foggy
Veeam Software
 
Posts: 14086
Liked: 1027 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby jim3cantos » Tue Apr 28, 2015 2:34 pm

foggy wrote:Currently logs grabbed during the backup can be replayed on the database from their corresponding parent VM backup only. No way to apply them to replica VM.


I think I have done test in point 1 above without problems in a DEV SQL server: planned failover + logs (from backup) applied to active replica + failback. Am I misunderstanding something?
jim3cantos
Enthusiast
 
Posts: 38
Liked: 5 times
Joined: Tue Jan 08, 2013 6:14 pm
Location: Madrid, Spain
Full Name: José Ignacio Martín Jiménez

[MERGED] Failover plan - SQL Replication - Transaction Log

Veeam Logoby Infin3ty » Fri May 08, 2015 9:49 am

Hello there,

I'm looking for some advice in the following:
We have an SQL server and a Exchange Server, we would like to replicate these servers once a day to an other datacenter for Failover purpose.

In case of an Emergency, we would like to use the replicated VM and restore the latest Transaction logs so the dataloss is minimal.

Next, We would also like to use Failover Plans to automate on and another.

What is best practice in this one?
Thanks in advance
Infin3ty
Lurker
 
Posts: 2
Liked: never
Joined: Fri Jul 13, 2012 10:45 am
Full Name: Henkjan Hilarius

Re: Feature Request - SQL T-Log backups in replica/backup co

Veeam Logoby foggy » Fri May 08, 2015 9:27 pm

I would appreciate if Jose could describe the way he was able to do what he has mentioned above. Most likely he had to use native tools for logs replay on replica VM.
foggy
Veeam Software
 
Posts: 14086
Liked: 1027 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Next

Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], Juraj G., ober72, pdkilian, RJI and 47 guests