Comprehensive data protection for all workloads
Post Reply
Stabz
Veeam Legend
Posts: 173
Liked: 21 times
Joined: Apr 07, 2017 7:40 am
Full Name: Philippe DUPUIS
Contact:

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

Post by 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!
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 526 guests