Backup of enterprise applications (Microsoft stack, IBM Db2, MongoDB, Oracle, PostgreSQL, SAP)
Post Reply
oscarm
Service Provider
Posts: 62
Liked: 7 times
Joined: Sep 10, 2013 11:43 am
Full Name: Oscar Muntenaar
Contact:

backup physical sql always on with Veeam agents

Post by oscarm »

All,

I have a customer that has an always on sql setup based on physical machines. I have build a test environment and have installed Veeam agents on the primary node and the secondary (readonly) node. If I backup the primary one it states skipping always on database: and then enummerates all always on databases. If I backup the secondary node it looks like application aware processing does not take place at all.

Is it possible to backup this setup with agents, and if so, how do I do that?
Dima P.
Product Manager
Posts: 15038
Liked: 1887 times
Joined: Feb 04, 2013 2:07 pm
Full Name: Dmitry Popov
Location: Prague
Contact:

Re: backup physical sql always on with Veeam agents

Post by Dima P. »

Hello Oscar,

This behavior is expected when using Veeam Agents with SQL Always On Availability Groups. Veeam Agents do not support application‑aware backups of SQL Always On AG databases. As a result: On the primary replica, application‑aware processing detects the Always On configuration and intentionally skips AG databases. On the secondary (read‑only) replica, SQL VSS integration is not triggered, so application‑aware processing does not run at all.

This is the recommended and fully supported approach - Backup of Always On Availability Groups (VBR User Guide). Hope it helps!
oscarm
Service Provider
Posts: 62
Liked: 7 times
Joined: Sep 10, 2013 11:43 am
Full Name: Oscar Muntenaar
Contact:

Re: backup physical sql always on with Veeam agents

Post by oscarm »

thanks Dima!
oscarm
Service Provider
Posts: 62
Liked: 7 times
Joined: Sep 10, 2013 11:43 am
Full Name: Oscar Muntenaar
Contact:

Re: backup physical sql always on with Veeam agents

Post by oscarm »

Dima,
I had a read of that guide, but that is for when you use a VBR server. So if you have physical servers and Always on SQL you do need a VBR server in order to get this backed up properly?
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests