Comprehensive data protection for all workloads
Post Reply
noah
Influencer
Posts: 15
Liked: never
Joined: Jan 05, 2022 5:54 am
Full Name: yongmuk im
Contact:

Backup of AlwaysOn Availability Groups Question

Post by noah »

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 :D
HannesK
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

Post by HannesK » 1 person likes this post

Hello,

Q1: probably yes :-)

Q2: yes, the same options should be used. Veeam automatically detects from where to get the logs

Best regards,
Hannes
noah
Influencer
Posts: 15
Liked: never
Joined: Jan 05, 2022 5:54 am
Full Name: yongmuk im
Contact:

Re: Backup of AlwaysOn Availability Groups Question

Post by noah »

Hello, Hannesk.

Thank you for your reply. :D

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.
HannesK
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

Post by HannesK » 1 person likes this post

Hello,
wants to get a transaction log backup only for DB-02.
That's a setting on the SQL side. The preferred host / secondary / primary / any with priority.

Probably restore works fine, but I would still fix it ;-)

Best regards,
Hannes
Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 78 guests