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!