VMCE_V12 · Question #196
A new Microsoft SQL database has been created on a new virtual server. A virtual machine backup job was created and executed. After testing, it was found that the database could not be recovered to…
The correct answer is C. Enable application-aware processing in the guest processing section of the job. Configure. You need to enable SQL-aware processing so Veeam will truncate and back up transaction logs at the interval you specify, allowing point-in-time restores. In your VM backup job's Guest Processing settings: - Enable application-aware processing - Go into the SQL database settings…
Question
A new Microsoft SQL database has been created on a new virtual server. A virtual machine backup job was created and executed. After testing, it was found that the database could not be recovered to a fine-tuned point in time. What must be changed on the backup job to perform the recovery?
Options
- AUse the guest interaction proxy setting to complete the database backup Disable application-
- BMake sure to set the advanced option to the incremental backup mode in the storage section of
- CEnable application-aware processing in the guest processing section of the job. Configure
- DMake sure the server is selected in the Virtual Machines tab, then select the database using the
How the community answered
(59 responses)- A10% (6)
- B3% (2)
- C81% (48)
- D5% (3)
Explanation
You need to enable SQL-aware processing so Veeam will truncate and back up transaction logs at the interval you specify, allowing point-in-time restores. In your VM backup job's Guest Processing settings: - Enable application-aware processing - Go into the SQL database settings and configure the log backup options for your desired interval (e.g., every 15 minutes) This will capture the log tail and give you fine-grained recovery points for your new database.
Topics
Community Discussion
No community discussion yet for this question.