Does anyone know how to create an alert when, for whatever reason, an Azure SQL Database backup fails to complete?

CodePudding user response：

You can use Azure Monitor service to create alert for Backup failure.

1. Search for Monitor in Azure Portal. Click on alerts under Monitor.

2. Click on Create -> Alert rule.

3. Click Scope and select the required fields.

4. Under Condition tab, select the option Activity log and select Signal name as Export an existing database as shown in below image.

5. Select the alert logic.

5. Under Action tab, create a New action group or use existing group.

6. In the action group, create an alerts like Email, SMS or Voice call and click on OK.