Hello
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
-
- Influencer
- Posts: 15
- Liked: never
- Joined: Jan 05, 2022 5:54 am
- Full Name: yongmuk im
- Contact:
-
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Backup of AlwaysOn Availability Groups Question
Hello,
Q1: probably yes
Q2: yes, the same options should be used. Veeam automatically detects from where to get the logs
Best regards,
Hannes
Q1: probably yes
Q2: yes, the same options should be used. Veeam automatically detects from where to get the logs
Best regards,
Hannes
-
- Influencer
- Posts: 15
- Liked: never
- Joined: Jan 05, 2022 5:54 am
- Full Name: yongmuk im
- Contact:
Re: Backup of AlwaysOn Availability Groups Question
Hello, Hannesk.
Thank you for your reply.
The customer is worried about the load and wants to get a transaction log backup only for DB-02.
The backup ended with warning, but is there any problem with the recovery?
Sincerely,
Noah.
Thank you for your reply.
The customer is worried about the load and wants to get a transaction log backup only for DB-02.
The backup ended with warning, but is there any problem with the recovery?
Sincerely,
Noah.
-
- Product Manager
- Posts: 14844
- Liked: 3086 times
- Joined: Sep 01, 2014 11:46 am
- Full Name: Hannes Kasparick
- Location: Austria
- Contact:
Re: Backup of AlwaysOn Availability Groups Question
Hello,
Probably restore works fine, but I would still fix it
Best regards,
Hannes
That's a setting on the SQL side. The preferred host / secondary / primary / any with priority.wants to get a transaction log backup only for DB-02.
Probably restore works fine, but I would still fix it
Best regards,
Hannes
Who is online
Users browsing this forum: Semrush [Bot] and 78 guests