Can veeam backup logs for AlwaysOn Second Replica

Discussions specific to Microsoft Hyper-V hypervisor

Can veeam backup logs for AlwaysOn Second Replica

Veeam Logoby Someonenew2014 » Fri Jan 08, 2016 11:08 pm

Hi Folks,

We are testing AlwaysON (2014) with Veeam v8.

According to documentation "Logs are backed up for the only one AlwaysOn Availability Group node selected"
http://helpcenter.veeam.com/backup/80/v ... pport.html

So Simply Veeam is taking full backup of both nodes primary and secondary replica, However , transaction log backup taken for one node and under specific situation that mentioned in the link above.

My Question.
1- In the recorded Webinar? they mentioned that we can take a transaction log backup for secondary replica?

Webinar
https://www.veeam.com/videos/veeam-micr ... -5939.html

Is that right? If yes, how.
Someonenew2014
Enthusiast
 
Posts: 58
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Can veeam backup logs for AlwaysOn Second Replica

Veeam Logoby Someonenew2014 » Thu Jan 14, 2016 8:05 am

We came into conclusion is that If you have primary and 2 secondary configured with ALwaysOn group

if you run transaction log backup at any one of the nodes it is enough. The AlwaysOn work in mechanism that notify other nodes when Tlog done on one of the nodes.


Veeam is taking the backup on primary/secondary according to backup properties of AlwaysOn AGs under MSSQL


I hope this help.
Someonenew2014
Enthusiast
 
Posts: 58
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Can veeam backup logs for AlwaysOn Second Replica

Veeam Logoby alexander sh » Thu Jan 14, 2016 9:28 pm

As one of the authors of the webinar series that you posted, I can confirm your findings.
AlwaysOn Availability Groups log backup algorithm makes sure that log backup can be taken from any replica. After log backup is taken, transaction logs are truncated across all the replicas in a consistent manner.

Backing up transaction logs from a secondary replica is a good way to do load balancing in AlwaysOn and is fully supported by Veeam.
alexander sh
Veeam Software
 
Posts: 23
Liked: 16 times
Joined: Thu Dec 13, 2012 8:52 am
Full Name: Alexander Shelemin

Re: Can veeam backup logs for AlwaysOn Second Replica

Veeam Logoby Someonenew2014 » Sun Jan 17, 2016 6:07 pm

Exactly. Thanks.
Someonenew2014
Enthusiast
 
Posts: 58
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Can veeam backup logs for AlwaysOn Second Replica

Veeam Logoby rayfox » Wed Dec 20, 2017 7:15 am

Apologies for bringing up this topic again but there is a certain ambiguity between the Veeam documentation and the quoted webinar, and in the webinar itself.

The question is:
Does Veeam support and manage the following scenario?:
SQL Server AlwaysOn availability group configuration with primary and secondary replicas on each node - i.e. on each SQL Server node there are both primary and secondary replicas.
Can Veeam take the transaction log backups required on both nodes, even though it does a "copy only" backup on each node that has at least one secondary replica (from Veeam documentation)?

Thanks,
ray
rayfox
Lurker
 
Posts: 2
Liked: never
Joined: Wed Dec 20, 2017 6:17 am
Full Name: Ray Fox

Re: Can veeam backup logs for AlwaysOn Second Replica

Veeam Logoby foggy » Thu Dec 21, 2017 4:23 pm

Hi Ray, yes, this scenario is supported, logs are backed up. Just keep in mind the recommendation to place both nodes into a single job.
foggy
Veeam Software
 
Posts: 15600
Liked: 1162 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 1 guest