Skip to main content
Answer

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

  • May 30, 2024
  • 6 comments
  • 833 views
N
Forum|alt.badge.img+1

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.

Best answer by coolsport00

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.

    coolsport00
    Link State
    dloseke

    6 comments

    coolsport00
    Forum|alt.badge.img+21
    • coolsport00
    • Veeam Legend
    • May 30, 2024

    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
    dloseke
    N
    Link State
    Forum|alt.badge.img+11
    • Link State
    • Veeam Legend
    • May 30, 2024

    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| AZ500|AZ305 - AWS Cloud Practitioner - VMWare: VCP-DCV Vsphere 7.x - Cisco: CCNA (Expired)
    Link State
    dloseke
    N
    coolsport00
    Forum|alt.badge.img+21
    • coolsport00
    • Veeam Legend
    • May 30, 2024

    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
    Link State
    dloseke
    N
    N
    Forum|alt.badge.img+1
    • Nikks
    • Author
    • Influencer
    • May 30, 2024

    Thank you all for the advise. 

    coolsport00
    dloseke
    dloseke
    Forum|alt.badge.img+8
    • dloseke
    • Veeam Vanguard
    • May 30, 2024

    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 Vanguard 2025 | Veeam Legend 2022-2024 | VMSP/VMTSP | VCP6-DCV | VSP/VTSP | CCNA | https://technotesanddadjokes.com | @dloseke
    marco_s
    Link State
    L
    coolsport00
    Forum|alt.badge.img+21
    • coolsport00
    • Veeam Legend
    • Answer
    • June 19, 2024

    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
    Link State
    vAdmin
    Terms & ConditionsAccessibility statement