Skip to main content
Question

Testing SQL Server AlwaysOn in SureBackup - Script-based verification experiences?

  • July 2, 2026
  • 1 comment
  • 9 views
Stabz
Forum|alt.badge.img+9

Hi everyone,

I'm looking for real-world experiences from anyone who has successfully (or unsuccessfully) tested SQL Server AlwaysOn Availability Groups using SureBackup with custom verification scripts.

I tryed to use the predefined SQL script but it failed.
 

My Setup:

  • 2-node Windows Server Failover Cluster (WSFC) with SQL Server 2022
  • AlwaysOn AG configured with synchronous commit
  • Veeam B&R 12.3.2 with Virtual Lab 

Goal: Validate SQL recoverability without triggering production cluster conflic

Has anyone written a PowerShell/ that handles AG verification inside the Virtual Lab (accounting for possible quorum loss)?

If you've done this (or tried and hit issues), I'd love to hear about your experience!

Philippe DUPUIS |Veeam Certified Engineer | https://original-network.com/

    1 comment

    D
    Forum|alt.badge.img+3
    • ddomask
    • Influencer
    • July 3, 2026

    Hi ​@Stabz

    What sort of issues with the built-in checker? Probably a Support Case is best there, the provided sample testing tools for SureBackup are supported, though I will note that the built-in checks are very simple. If I remember right, all it does is check that the SQL service comes up by checking that it’s listening on the default SQL port in the vLab.

    https://github.com/VeeamHub/powershell/tree/master/BR-Surebackup-SQLCheck

    I have not tested these personally, but I know the author and the script itself looks pretty normal, it establishes a SQL Connection and checks a few DBs returned by the queries. 

    I think Tim wrote this for Sharepoint, but it will work with MSSQL, and you can probably use this as a template to add your checks for AG health by editing / adding an additional command in the try / catch statement.

    0x0D 0x0A
    Terms & ConditionsAccessibility statement