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.

Hi @scottsanpedro, did you found the solution? Currenly I have exactly the same requirements, also for an ISO accreditation — Yurii Paneiko, Dec 22 '21 at 17:28

score 1 · Answer 1 · answered Jul 01 '21 at 07:51

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

answered Jul 01 '21 at 07:51

Venkataraman R

12,181
2
31
58

Thank you @VenkataramanR, I will withdraw my reply – Francesco Mantovani Jul 01 '21 at 08:03
@FrancescoMantovani, no problem – Venkataraman R Jul 01 '21 at 08:34
Thanks. I will take a look and comment. – scottsanpedro Jul 02 '21 at 10:47

score 0 · Answer 2 · answered Jul 01 '21 at 10:55

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

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

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

Please Refer: Click here

Required. SQL Azure Backup Alerts

2 Answers2