Required. SQL Azure Backup Alerts

Question

SQL Azure backups. Is there a way to get emails alerts when the backup's are processed? I have a client that needs this for an ISO accreditation.

Answer 1

You can configure Azure storage blob events to observe new backup blobs being created. You can filter for your need : full backup, differential backup, transaction log backup.

Now, you can handle the events accordingly using event handlers and send email.

More information on Azure Storage Blob Events

Answer 2

Azure SQL Backup Email Alert is not available. We can achieve using

1. You have SQL in Azure VM use Recovery Services Vaults

Search the Recovery Service Vault in Azure portal

Open Recovery Service Vault and Create a new Recovery Service Vault and add required details

Open created Recovery Service vault and select Backup Alerts.

Select Configure notification

Select Email notification ON and add Recipient’s Email which you want to receive alert and save it.

After successful configuration you can receive the alert mail. Please Refer: Click here

2. For alternate solution: Create Alert to Monitor (You have Azure SQL Server Database without VM)

Please Refer: Click here