How to Use A Build Pipeline To Request A Database Backup

Submitted by Nathan Clouse on 10/23/22.

Last modified: 

01/12/23

Tags: 

 

PowerShell in a pipeline to request a database backup.

PowerShell is a powerful scripting language that can be used to automate a wide variety of tasks, including interacting with Azure DevOps pipelines. One common use case for PowerShell in an Azure DevOps pipeline is to request a database backup. This can be accomplished by using the LCS REST API to trigger a backup of a specific database, and then using PowerShell to monitor the status of the backup. This approach allows for a high level of automation and flexibility, allowing developers to easily schedule and manage database backups as part of their overall development workflow.

The Rundown, Again

All of the prerequisites to use this are available in this article. Nothing has changed. We're just hitting a different endpoint. To use this script, you'll need the following:

  1. A user without MFA enabled in the LCS project with LCS permissions to request a database backup
  2. LCS Project ID
  3. Knowledge of LCS instance environment is in
  4. LCS Environment ID

Once you have all of that, you can use this script to create a pipeline to request a database backup on whatever schedule you'd like. The script will start a database backup operation, pause, then confirm the request was accepted.