VMCE_V12 · Question #187
A company has backup issues because the Veeam Backup & Replication Configuration Database crashes, causing corruption to the configuration database. Sometimes the administrator has to recreate the…
The correct answer is A. Use a Microsoft SQL Always On Availability Group and back up using the configuration backup. Always On Availability Group provides automatic failover and redundancy for the SQL instance hosting the Veeam DB, eliminating a single point of failure. Configuration backup tool (the scheduled "Configuration Backup" job in Veeam) still runs against the AG listener, giving you…
Question
A company has backup issues because the Veeam Backup & Replication Configuration Database crashes, causing corruption to the configuration database. Sometimes the administrator has to recreate the backup jobs after a crash. The administrator needs to redesign the Veeam Backup & Replication solution to minimize issues with the configuration database. How should the administrator configure the Veeam Backup & Replication Configuration Database?
Options
- AUse a Microsoft SQL Always On Availability Group and back up using the configuration backup
- BUse Microsoft SQL Server installed directly on the Veeam Backup & Replication server and make
- CUse a PostgreSQL cluster and back up using the configuration backup tool.
- DUse PostgreSQL installed on a separate server and make hourly backups using application-
How the community answered
(57 responses)- A82% (47)
- B4% (2)
- C4% (2)
- D11% (6)
Explanation
Always On Availability Group provides automatic failover and redundancy for the SQL instance hosting the Veeam DB, eliminating a single point of failure. Configuration backup tool (the scheduled "Configuration Backup" job in Veeam) still runs against the AG listener, giving you point-in-time snapshots of the DB schema and metadata in case you need to restore to an earlier state.
Topics
Community Discussion
No community discussion yet for this question.