performing automatic SQL restores

Hi ​@Egor Skepko 
Good day!

The preferred method for performing automatic SQL restores in Commvault is to use the REST API.!--startfragment>

REST API is the preferred method for automatic SQL restores due to its flexibility, reliability, and integration capabilities.

CLI with XML is also reliable and suitable for environments where direct CommServe access is available.

PowerShell is less preferred due to known issues and limited support for advanced restore scenarios.

PowerShell

PowerShell can be used for automation, but there are known issues with point-in-time restores (PIT) via PowerShell, such as incorrect timestamps being set, which can cause restore failures.

CLI with XML File

The CLI method using qoperation execute with an XML file is reliable and widely supported, but it requires access to the CommServe and is less flexible for remote or cloud-based automation.

REST API

The REST API is the recommended and most flexible method for automation. It allows you to browse, initiate, and monitor SQL restore jobs programmatically from any environment that can make HTTP requests.

REST APIs are supported for SQL restores, including in-place, out-of-place, and point-in-time restores.

Refer

https://api.commvault.com/docs/SP40/api/cv/MSSQL_API/mssql-restores

!--endfragment>

I would always lead with REST API solutions first.

Thanks,
Scott
 

​@Scott Moseman and ​@Syed_S 

Thanks for the information, maybe one of you has an example of the script that I can run.