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

[Stabz]

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!

[PetrM]

Hi Philippe,

I believe it would be best to contact our Support team to clarify the root cause of the failure.

Thanks!

[Stabz]

Hello Petr,

I have open a ticket in parallele, I tryed here in case someone did a special script for this case !

[david.domask]

Hi Stabz,

I answered you on your topic on Community Forums, but will cross-post here as well:

https://github.com/VeeamHub/powershell/ ... p-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 with Sharepoint in mind, 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.

So really depends on what you want to test, but you can probably use this script as a template with SureBackup and add in whatever tests you want, but agree with Petr that it's best to understand why the built-in checker failed, as if it's connectivity issue, then another script trying to connect will likely fail as well.