Host-based backup of VMware vSphere VMs.
Post Reply
minkee
Lurker
Posts: 1
Liked: never
Joined: Feb 10, 2022 1:05 pm
Full Name: Bob Moda
Contact:

VM backup of SQL AlwaysOn AG clusters - backup of duplicate data

Post by minkee »

The current problem I'm facing is we are doing VM Image-based, SQL application-aware backups of our 3 node SQL AlwaysOn Availability Group clusters.

These VMs are huge and so are the respective data volumes with 15TB of data per VM node.

This is clobbering the backup infrastructure in terms of capacity as you can imagine. The thing is that the DB and Log drives are exactly the same across all 3 nodes so would it be possible to exclude the data (DB and log) drives from the backups on 2/3 nodes - apart from the single secondary node which is used to perform the SQL application-aware backup?

As this would save a massive amount of backup space...
Andreas Neufert
VP, Product Management
Posts: 6749
Liked: 1408 times
Joined: May 04, 2011 8:36 am
Full Name: Andreas Neufert
Location: Germany
Contact:

Re: VM backup of SQL AlwaysOn AG clusters - backup of duplicate data

Post by Andreas Neufert »

The issu with this approach is that you will not have a real disaster recovery for the system and you relay on the integrity of one of the servers. I saw so many situations over time where replication stopped working and you had only backups of this corrupt system then.

I would go maybe a different path and would look into deduplication.

You can use Veeam deduplication with Per-Job backupchain and include all 3 servers to the job. Potentially go a bit lower on the block size to optimize dedup.
You could use some software dedup from Microsoft as well or go with one of our supported deduplication appliances.
This would save you the space while continue to provide real disaster recovery.
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 46 guests