Restore SQL Server database using data management provider REST API


The more SQL Server instances we need to manage, the easier it gets relying on third-party tools to complete our daily tasks. However, this brings another problem, that is, integrating with any application through the interfaces they provide. A very common request is to perform a database restore, and the reasons are many: development, testing, address a production issue, view deleted data, disaster recovery, etc. If we knew where the backup files are located (full, diff and log), it’s a matter of running T-SQL commands. If we have a data management provider we depend on their website and/or API to perform