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?

Question

Options

• AVeeam Backup and Replication - Create a VMware backup job, include the 3 nodes of the cluster.
• BVeeam Agent for Windows - Create a managed by server backup job for all 3 nodes. Use
• CVeeam Agent for Windows - Create a managed by agent backup policy for all 3 nodes. Use a log
• DVeeam Enterprise Plug-in for Microsoft SQL - Install the Plug-in on each node in cluster. Use

• A
  81% (29)
• B
  6% (2)
• C
  11% (4)
• D
  3% (1)

Explanation

For backing up a 3-node Microsoft SQL Always On cluster running in a VMware environment with the specified Recovery Point Objectives (RPOs), the most suitable option is 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. This approach allows for the entire SQL cluster nodes to be backed up as part of a regular VM backup job, which satisfies the 1-day RPO for the cluster nodes. The Application-Aware Processing feature of Veeam Backup & Replication ensures that the SQL databases are in a consistent state during backup. Moreover, this feature allows for the transaction logs to be backed up separately at a more frequent interval, in this case, every 15 minutes, meeting the 15-minute RPO requirement for the log files. This dual approach ensures comprehensive protection for both the SQL cluster nodes and the critical transaction logs, aligning with the specified RPOs.

No community discussion yet for this question.