Skip to main content
  • EN
Solved

what is the best way to backup a 2 node cluster SQL VM

Regarding the backup configuration for a 2-node cluster with SQL Always On:

 

Am i doing the correct process for backup  ?

  1. add the cluster in the protection group.
  2. Create the backup job as a Failover cluster.
  3. Backup entire computer.
  4. Enabling guest processing for taking SQL Backup & Log backups.

 Concerning restoration:

  1. What are the types of restores that can be performed ?
  2. How to perform the restore the complete failover cluster and the SQL  Application with Always on using Veeam if the failover cluster servers are crashed.

6 comments

coolsport00
Userlevel 7
Badge +19

Hi @Nikks -

I’ve not done this myself...maybe others have. But, have you looked in the User Guide for SQL AO Supportability?

https://helpcenter.veeam.com/docs/backup/vsphere/alwayson_support.html?ver=120

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00
Link State
Userlevel 7
Badge +10

hi @Nikks 

this can help

[GUIDE] How To deploy & schedule Veeam Agent Protection Group MS Cluster step by step | Veeam Community Resource Hub

you can check out the detailed guides on the veeam site

Backup of Always On Availability Groups - Veeam Agent Management Guide

Step 5. Specify AlwaysOn Restore Options - Veeam Backup Explorers Guide

 

Backup and Restore of Failover Clusters - Veeam Agent Management Guide

Failover Cluster Support - Veeam Agent Management Guide

Veeam: VMCA | VMCE | VMXP | Veeam Legend - Microsoft: MCITP | MCP | MCSA | 2008 R2 | 2012R2 | 2016 | MCSE Core Infrastructure | MCSE Cloud Platform - Azure: AZ900 | AZ104 - VMWare: VCP-DCV Vsphere 7.x - Cisco: CCNA (Expired)
coolsport00
Userlevel 7
Badge +19

The Veeam BP Guide also has some info to check out:

https://bp.veeam.com/vbr/4_Operations/O_Application/mssql_server.html

As well as a couple Forums posts to reference a similar question as yours:

https://forums.veeam.com/vmware-vsphere-f24/best-way-to-backup-always-on-sql-cluster-multi-istance-t71912.html

https://forums.veeam.com/veeam-backup-replication-f2/backing-up-always-on-mssql-with-veeam-t18223-90.html

 

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00
N
Userlevel 5
Badge +1

Thank you all for the advise. 

dloseke
Userlevel 7
Badge +6

You’ll want to read the setup KB for this.  I haven’t set this up myself, but you need to install the MSSQL plugin on each node of the SQL failover cluster and then log into management studio on the active node and setup the backup job as a SQL Server Agent job as specified in the the KB.

https://helpcenter.veeam.com/docs/backup/plugins/mssql_plugin_cluster.html?ver=120

 

Rick has a YouTube video that touches on the job setup on this as well though it doesn’t touch on failover clustering.

 

 

Derek M. Loseke, Senior Systems Engineer | Veeam Legend 2022-2023 | VMSP/VMTSP | VCP6-DCV | VSP/VTSP | CCNA | https://technotesanddadjokes.com | @dloseke
coolsport00
Userlevel 7
Badge +19

Hi @Nikks -

I was just following up on your post here. Do you still have questions? If so, don’t hesitate to ask. But, if any of the provided comments helped you out, we ask you please mark one as ‘Best Answer’ so others with a similar question who come across your post may benefit.

Thank you.

Shane Williford - Veeam VMCA/VMCE | Veeam Legend | VUG Leader | VCP-DCV | Twitter: @coolsport00

Comment


Terms & Conditions