A 3-node Microsoft SQL Always On cluster is running in a VMware environment.
The RPOs are: • 1 day for the cluster nodes • 15 minutes for the log files
How should the cluster be backed up?
A.
Veeam Backup and Replication - Create a VMware backup job, include the 3 nodes of the cluster. Use Application-Aware Processing to back up the transaction logs every 15 minutes.
B.
Veeam Agent for Windows - Create a managed by server backup job for all 3 nodes. Use Application-Aware Processing to back up the database once a day.
C.
Veeam Agent for Windows - Create a managed by agent backup policy for all 3 nodes. Use a log shipping server to back up the transaction logs every 15 minutes.
D.
Veeam Enterprise Plug-in for Microsoft SQL - Install the Plug-in on each node in cluster. Use Microsoft SQL Server Management Studio to create the backups.
Always On Availability Groups with no underlying failover cluster (Clusterless Availability Groups) are not supported: https://helpcenter.veeam.com/docs/backup/agents/cluster_support.html?ver=120
To process Always On Availability Group, you must complete the following tasks:
In Veeam Backup & Replication, create a protection group that includes Active Directory objects. Add to this protection group the failover cluster account of the failover cluster whose data you want to back up.
https://helpcenter.veeam.com/docs/backup/agents/cluster_always_on_hiw.html?ver=120
When you follow the guide and select 'Failover Cluster' the only available mode is 'Managed by backup server'. So it's not C obviously. Then its prabably B.
"A"
Cluster-Aware, Image-Level Backups
Because the SQL Always On cluster runs on VMware VMs, the recommended approach is to perform an image-level backup from the hypervisor layer. Veeam Backup & Replication handles all three cluster nodes together, and it is cluster-aware when Application-Aware Processing is enabled.
Meets Both RPOs
1 day for the VM-level backup: You can schedule your primary backup job (with snapshots of each VM) to run daily (or as often as needed).
15 minutes for transaction logs: Application-Aware Processing in Veeam can capture transaction logs more frequently (e.g., every 15 minutes), ensuring minimal data loss.
Simplified Management
Everything is configured and monitored within Veeam Backup & Replication.
No need to install and manage a separate agent on each node.
No need for special log-shipping servers or SQL-native backups via SSMS.
I believe Veeam agent is used if there is no other way, so A in my mind.
Veeam Backup Agents are not just a last resort but rather a specialized tool for certain use cases, such as physical server backups, backup of systems not running on supported hypervisors, or granular, agent-specific backup needs. Veeam Backup & Replication remains the preferred solution for virtualized environments.
I think the Backup here has got two steps
- Backup of the Nodes over VMware Backup (Normaly once a day)
- Backup of the SQL Application-aware with Trans-Logs every 15 Minutes
Always On Availability Groups with no underlying failover cluster (Clusterless Availability Groups) are not supported: https://helpcenter.veeam.com/docs/backup/agents/cluster_support.html?ver=120
To process Always On Availability Group, you must complete the following tasks:
In Veeam Backup & Replication, create a protection group that includes Active Directory objects. Add to this protection group the failover cluster account of the failover cluster whose data you want to back up.
https://helpcenter.veeam.com/docs/backup/agents/cluster_always_on_hiw.html?ver=120
The question is : A 3-node Microsoft SQL Always On cluster is running in a "VMware environment."
Because the "vmware environnement" word, we can deduct than the nodes are VM, so the only solution for me it's A.
B does not mention to backup the transaction logs every 15 mins
upvoted 5 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
05884b2
Highly Voted 7 months, 1 week agodredlinee
5 months agoSixthSense
Most Recent 2 weeks, 1 day agoJanoss
1 month ago95373f6
1 month, 1 week agoc98e18b
6 months, 2 weeks ago05884b2
7 months, 1 week agoLinkin27
9 months agoPubbert
9 months, 1 week agoflorian98w
9 months, 1 week agobpexam
9 months, 3 weeks agomaxustermann
9 months, 1 week ago