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!
PetrM
Veeam Software
Posts: 4192
Liked: 747 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

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

Post by PetrM »

Hi Philippe,

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

Thanks!
Post Reply

Who is online

Users browsing this forum: Amazon [Bot], DuckDuckGo [Bot], Google [Bot], Semrush [Bot] and 899 guests