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
-
- Novice
- Posts: 8
- Liked: never
- Joined: Mar 19, 2021 10:35 am
- Contact:
-
- Product Manager
- Posts: 14726
- Liked: 1707 times
- Joined: Feb 04, 2013 2:07 pm
- Full Name: Dmitry Popov
- Location: Prague
- Contact:
Re: Backup Job Design for SQL AAG Backups
Hello Stede,
It's up to you - both options are supported and work without any issues. Thanks!
It's up to you - both options are supported and work without any issues. Thanks!
Who is online
Users browsing this forum: No registered users and 9 guests