Hi guys,

We have a number of projects running in Umbraco Cloud utilising the baselines feature.

We want to initiate and story backups of the sites within our own Azure Blob Storage.

In the documentation there are details of how to run a powershell script to produce backups.

https://our.umbraco.com/documentation/Umbraco-Cloud/Databases/Backups/#backup-with-powershell-script

My question is - is anybody aware of a possible solution for having this scheduled / running in VSTS? Either on a schedule or as part of deployment pipeline?

I can run a powershell script as part of a pipeline however it doesn't / won't have access to the SQL Server Management dll that is required to run the backup.

Is this possible? And/or is there another way to achieve this? I want to get away, ideally, from this being a process that we run on our local machines. Another option would be to have a VM running this process within azure but that too seems overkill.

Thanks, Luke