Restore Azure Sql Database backup using Devops pipeline

cargt3 1 Reputation point
2021-02-18T16:48:12.203+00:00

I have scenario where i need to manually create backup of azure sql database and store i for long time. I have to be able to restore it on demand by users whom dont have access to azure for example by running Devops pipeline.

regards

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 22,721 Reputation points
    2021-02-19T03:57:24.507+00:00

    Hey @cargt3 ,
    Azure Devops supports Powershell task and you can use powershell to create and restore the backups.
    You can refer the below therad :
    https://stackoverflow.com/questions/43449783/backup-azure-sql-db-during-vsts-release

    for detailed clarity on the steps

    0 comments