Host-based backup of Microsoft Hyper-V VMs.
Post Reply
titus.bandugula
Novice
Posts: 6
Liked: never
Joined: Nov 13, 2022 1:10 pm
Full Name: Titus Bandugula
Contact:

SQL-DB, Domain Controller VM backups

Post by titus.bandugula »

Hello Team,

I have multiple VMs running on Windows Hyper-Visor Cluster with MS-SQL DB (standalone, Cluster, AG mode), Domain Controllers and Filesystem Clusters.
What's the best practice to create these jobs ?
Should I have a single job for the entire Hyper-V Cluster (400+ VMs) and segregate the SQL-DB, Domain Controllers with application aware ?
Should I have multiple jobs for SQL-DB, VMs, Domain Controllers, Filesystem Clusters . Please help.
Also, I heard the Veeam12 uses agent to backup the SQL-DB can anyone help with this ? I don't see SQL-DB agent in my account downloads.
PetrM
Veeam Software
Posts: 3329
Liked: 539 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: SQL-DB, Domain Controller VM backups

Post by PetrM »

Hello,

I don't think that there is a best practice, it's up to you how you prefer to organize jobs. I believe it mainly depends on schedule and on repository where you're going to store backups. From my point of view, it's easier to manage several jobs, it gives you more flexibility than with a single big job for 400+ VMs: what if you decide later to exclude a VM or add a new one or to move some backups to another repo, or change retention policy for some of them. For instance, you can group VMs by application type and create a job for every group.

I think you're asking about our new plug-in for Microsoft SQL, it has many advantages mainly for DBAs including high performance and scalability.

Thanks!
Post Reply

Who is online

Users browsing this forum: No registered users and 10 guests