Skip to main content
Solved

REST API to create MSSQL Server AvailabilityGroup

  • 28 February 2024
  • 4 replies
  • 92 views

Forum|alt.badge.img+3

I am working on automation which installs SQL iDataAgent on new clients and also creates AG (Availability Group) Instance.

I have found this API endpoint to push install the MSSQL iData Agent on the servers but I can’t find an example of creating AG Instance via API.

Best answer by Gseibak

@tonytony - if you don’t see the option then for 11.32 we can leverage XML for this - https://documentation.commvault.com/2023e/expert/mssql_availability_group_command_line_operations.html

the 3rd step in that procedure shows how to create using XML as input. 

 

Hope that helps.

View original
Did this answer your question?

4 replies

Forum|alt.badge.img+11
  • Vaulter
  • 115 replies
  • February 28, 2024

@tonytony - easiest way to handle this is by using the “equivalent API” option when you add the new one in Command Center. 

this will generate the API for you and then you can then modify it going forward as needed.

 

 


Forum|alt.badge.img+3
  • Author
  • Byte
  • 6 replies
  • March 1, 2024
Gseibak wrote:

@tonytony - easiest way to handle this is by using the “equivalent API” option when you add the new one in Command Center. 

this will generate the API for you and then you can then modify it going forward as needed.

 

 

I am using version 11.32.43 and I don’t have the equivalent API button. Can you send me the API Endpoint and JSON example?


Forum|alt.badge.img+11
  • Vaulter
  • 115 replies
  • Answer
  • March 1, 2024

@tonytony - if you don’t see the option then for 11.32 we can leverage XML for this - https://documentation.commvault.com/2023e/expert/mssql_availability_group_command_line_operations.html

the 3rd step in that procedure shows how to create using XML as input. 

 

Hope that helps.


Forum|alt.badge.img+3
  • Author
  • Byte
  • 6 replies
  • March 1, 2024

@Gseibak Thank you!


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