Comprehensive data protection for all workloads
Post Reply
Posts: 1
Liked: never
Joined: Jan 14, 2020 1:26 pm
Full Name: David Parsons

SQL Transaction Logs and Replication

Post by DP_CTUK » Jan 14, 2020 1:33 pm

The customer requirement is to give their DR the least SQL data loss reasonably possible without having to app-aware process the machine for replication every hour or two.

Currently considering replicating to our Veeam DRaaS and also cloud connect backup to our Veeam BaaS.

I gather that you cannot ship transaction logs as part of a replication job. But if they ship them to the cloud at regular intervals (hourly or better), could we fail over to their replicated DR servers and them use the backup with transction logs to restore and/or roll-forward the SQL database on the replica?


Veeam Software
Posts: 18789
Liked: 1650 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL Transaction Logs and Replication

Post by foggy » Jan 14, 2020 2:36 pm 1 person likes this post

Hi David, yes, this is possible. Please keep in mind, that in this case the existing database on the replica VM will be deleted prior to being restored from the backup with subsequent logs replay.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], JohnW and 27 guests