Host-based backup of Microsoft Hyper-V VMs.
Post Reply
stede
Novice
Posts: 8
Liked: never
Joined: Mar 19, 2021 10:35 am
Contact:

Backup Job Design for SQL AAG Backups

Post by stede »

Hello,

we are runnning several virtual SQL AAG guest clusters.
We have started backing them up by configuring Hyper (S2D Clusters) VM Image Backups including Transaction Log Backups - it works.
In the Log for Transaction Log Backups one can see that VBR detects the SQL AAG and Log Backups are taken from only one SQL AAG node which is correct.

I wonder what is best practice:

1. Configuring one Backup Job for several SQL AAG Clusters oder
2. Creating one Backup Job for each SQL Cluster?

When adding several SQL Clusters to one Backup Job does the mechanism detecting AAG for Transaction Log Backups still work?

regards
Stede
Dima P.
Product Manager
Posts: 14415
Liked: 1576 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: Backup Job Design for SQL AAG Backups

Post by Dima P. » 1 person likes this post

Hello Stede,

It's up to you - both options are supported and work without any issues. Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 12 guests