Standalone backup agent for Microsoft Windows servers and workstations (formerly Veeam Endpoint Backup FREE)
Post Reply
Asahi
Expert
Posts: 160
Liked: 11 times
Joined: Jun 03, 2016 5:44 am
Full Name: Iio Asahi
Location: Japan
Contact:

About SQL Server transaction log backup from secondary node

Post by Asahi »

Hi,

When we have a WSFC+SQL Server (AlwaysOn) server, I believe we can use VAW to get image-based backups.
https://helpcenter.veeam.com/docs/backu ... ml?ver=120

At this time, is there any way to ensure that the SQL Server transaction log backup process performed after the image-based backup is always performed only from the secondary node? :D

Kind Regards,
Asahi,
Climb Inc.
marina.skobeleva
Veeam Software
Posts: 50
Liked: 20 times
Joined: Feb 10, 2020 1:48 pm
Full Name: Marina Skobeleva
Contact:

Re: About SQL Server transaction log backup from secondary node

Post by marina.skobeleva »

Hello Asahi,

You can select backup preferences for the Always On Availability Group.

When the job is processing an Always On Availability Group, Veeam Agent for Windows needs to select one node from which the logs will be transferred. The selection is done based on a several criteria, and one of them - backup preferences. More details regarding this topic you can find here.

Thank you.
Asahi
Expert
Posts: 160
Liked: 11 times
Joined: Jun 03, 2016 5:44 am
Full Name: Iio Asahi
Location: Japan
Contact:

Re: About SQL Server transaction log backup from secondary node

Post by Asahi »

Hi,

I was able to see the link and backup configuration successfully, thank you!

Kind Regards,
Asahi,
Climb Inc.
marina.skobeleva
Veeam Software
Posts: 50
Liked: 20 times
Joined: Feb 10, 2020 1:48 pm
Full Name: Marina Skobeleva
Contact:

Re: About SQL Server transaction log backup from secondary node

Post by marina.skobeleva »

Hi Asahi,

Happy to help :)

Thanks!
Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 9 guests