
I have a few questions.
Backup job always has a Warning.
==> VM DB-01 is configured for SQL transaction logs truncation, while another AlwaysOn node is configured to log backup.
Each VM backup succeeds, but the parent backup with 2 VMs has the above text and the result is a warning.
Ex) 1 Backup Job(2 VM)
->2 VM backup is success, Backup Job is Warning
Q1. Is the reason for the warning appearing wrong configuration of the backup job?
Q2. What is the best way to configure it?
Should DB-01 and DB-02 have the same application-aware processing function?(SQL : Backup logs periodically)
Should I set the DB-01 to Perform copy only?
[Notes]
- 1 VMware Backup Job
- 2 Objects : VM DB-01, VM DB-02
- Guest Processing check
- VM DB-01
-> General : Require successful processing, Process transaction logs with this job(recommended)
-> SQL : Truncate logs(prevents logs from growing forever)
- VM DB-02
-> General : Require successful processing, Process transaction logs with this job(recommended)
-> SQL : Backup logs periodically(120 Min), Until the corresponding image-level backup is deleted
Thanks
