Skip to main content
Solved

Restore Validate is not working on MS SQL Always on AVailability Group

  • 19 February 2024
  • 4 replies
  • 69 views

Forum|alt.badge.img+5

Hello All,

I am using restore validate workflow. IT worsk fine on standalone nodes. When I try is on MS SQL Always on it fails. Does COmmvault support it on MS SQL AG?

Best answer by DGarra

Team, 

 

Microsoft SQL doesn’t allow for the direct restore of databases into an availability group. The database must be dropped form the AG first, restored into the individual instance, and then manually rejoined to the AG back after. 

Our workflow won’t offer any options with an AG as a target, as it’s not a possible task based on the limitation of the AG. A restore asking for the AG as a target won’t list one either, etc. 

View original

DGarra
Vaulter
Forum|alt.badge.img+3
  • Vaulter
  • February 19, 2024

Team, 

 

Microsoft SQL doesn’t allow for the direct restore of databases into an availability group. The database must be dropped form the AG first, restored into the individual instance, and then manually rejoined to the AG back after. 

Our workflow won’t offer any options with an AG as a target, as it’s not a possible task based on the limitation of the AG. A restore asking for the AG as a target won’t list one either, etc. 


Forum|alt.badge.img+14

@ETO What @DGarra  said above plus would add the following

The workflow is running a verify only restore operation and will function similar to a restore with the same option set.
https://documentation.commvault.com/2023e/expert/advanced_restore_options_options_03.html

 

You can leverage the workflow and point it to a replica instance just not the AG client itself.


Forum|alt.badge.img+5
  • Byte
  • February 19, 2024

Thanks for answer guys. I know verfy from the subclinet opitons. BUt I want to use worfkflow option for several sql db’s. Because we are doing many restore tests every months. Worfkflow does it esiler. BUt as I understand wordkflow does not support for AG clients, becasue of limitations am I correct?


DGarra
Vaulter
Forum|alt.badge.img+3
  • Vaulter
  • February 19, 2024

Team, 

That’s correct. 

When saying that you’re testing restores however, keep in mind, that you can’t restore into an AG, so testing/validating the same process isn’t going to yield results either way. 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings