A Microsoft SQL server is running in a VMware VM. The VM is very sensitive to snapshots, and can only be snapshotted once per day at 3 AM. However, the RPO for the databases running inside the VM is…

Question

Options

• ASQL Tab: Choose how this job should process Microsoft SQL Server Transaction Logs: Back up
• BSQL Tab: Choose how this job should process Microsoft SQL Server Transaction Logs: Do not
• CGeneral Tab: VSS Settings: Perform copy only
• DSQL Tab: Choose how this job should process Microsoft SQL Server Transaction Logs: Truncate
• EGeneral Tab: VSS Settings: Process transaction logs with this job

• A
  74% (20)
• B
  4% (1)
• C
  15% (4)
• D
  7% (2)

Explanation

To meet the 1-hour RPO for the databases within the VM, while only being able to snapshot the VM once per day, the best strategy is to enable regular transaction log backups (option A) and process transaction logs with the job (option E). This setup allows the system to capture changes in the SQL Server transaction logs at intervals less than the RPO requirement, without needing to snapshot the entire VM more frequently.

No community discussion yet for this question.