Backup logs options with AlwaysOn AG ?

Hyper-V specific discussions

Backup logs options with AlwaysOn AG ?

Veeam Logoby Someonenew2014 » Tue Jan 05, 2016 12:43 pm

Hi,

I did a setup for SQL Server with AlwaysOn Availability group and the backup is successed through Veeam.

I can see from SQL is that Veeam is taking backup from Active node and discard the secondary node.
How this is work ?

I read
http://helpcenter.veeam.com/backup/80/e ... tings.html

but still not clear


My question what about backup log options in case of AlwaysON?

I want manage logs through Veeam as well.

1) Truncate logs (recommended)
2) Do not truncate logs (Sore not suitable)
3) Backup logs (every 15 minutes)

I cannot see the transaction log backup from SQL server ? Did I miss something here??

How can choose the primary or secondary from Veeam setting.

BTW we are using version 8


Thank you all in advance.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Backup logs options with AlwaysOn AG ?

Veeam Logoby foggy » Tue Jan 05, 2016 4:29 pm

Please review this user guide section and this thread for some considerations.
foggy
Veeam Software
 
Posts: 14728
Liked: 1078 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Backup logs options with AlwaysOn AG ?

Veeam Logoby Someonenew2014 » Tue Jan 05, 2016 5:58 pm

Thanks foggy for fast response.

I read them before I do the post.sorry it is not clear for me.


I need direct answer without explanation.


From your reply
"AG nodes do not necessarily need to be backed up in a single job. What is much more important, is that transaction logs backup should be performed only in one job - if some of the nodes are backed up by a different job, this job should have the 'Do not truncate' setting selected for these VMs"

I put it in a single job for both nodes? Primary success while Secondary failed.

Both VMs configured backup logs every 15 minutes? is it Ok. I cannot see it from database.

Is Veeam AlwaysOn Aware? means only take the backup primary
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Backup logs options with AlwaysOn AG ?

Veeam Logoby Someonenew2014 » Thu Jan 07, 2016 8:01 am

Thanks. Opened a case with Veeam and they answer our concern.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Backup logs options with AlwaysOn AG ?

Veeam Logoby v.Eremin » Thu Jan 07, 2016 8:27 am

It'd be appreciated, if you provide a resolution for the convenience of future readers.

As far as I remember, you should enable log truncation option for desired node and leave "do not truncate" for the other one, because as UG states "Logs are backed up for the only one AlwaysOn Availability Group node selected". Is that what support team responded?

Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin

Re: Backup logs options with AlwaysOn AG ?

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

Thanks.

We are still discussing with them.

The answer is

"Logs are backed up for the only one AlwaysOn Availability Group node selected". To become a subject for log backup, the node must meet the following criteria:

▪Required Veeam Backup & Replication components can be installed on that node (in particular, the VM must be running).
▪If there are any logs remaining in the temporary folder on that node of AlwaysOn Availability Group, this means they were not backed up to the destination repository during the previous log backup session, so this AlwaysOn Availability Group node must be processed first.
▪Databases in the AlwaysOn Availability Group(s) for that node were successfully backed up (for the last two processing intervals).
▪Node availability over the network [is preferred, otherwise via VIX].
▪The VM is in the list of preferred nodes (for backup) retrieved from the Microsoft SQL Server. If there are no preferred nodes, then any node can be chosen.



========================================
Only one node get backup-ed up in terms of transnational log. Full backup is taking to both nodes.

Tested with Veeam and verified.
Someonenew2014
Enthusiast
 
Posts: 54
Liked: 3 times
Joined: Wed Feb 04, 2015 8:25 pm

Re: Backup logs options with AlwaysOn AG ?

Veeam Logoby v.Eremin » Mon Jan 11, 2016 9:41 am

Got it. Feel free to contact us, if other questions arise. Thanks.
v.Eremin
Veeam Software
 
Posts: 13266
Liked: 968 times
Joined: Fri Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin


Return to Microsoft Hyper-V



Who is online

Users browsing this forum: No registered users and 8 guests