How to enable Azure SQL Managed Instance Drop/Deletion Event logs

Question

We have an Azure SQL MI having number of databases on it . We have to enable audit logs of SQL MI from diagnostic settings and also enabled logs by executing queries on MI and sending those logs to event hub. We are getting up logs (select, Execute) but not able to see the logs related to database drop/delete activity

the blog (https://docs.imperva.com/en-US/bundle/cloud-data-security/page/78051.htm) I am using the for enabling audit log in Azure SQL MI, what I am missing any step

plus we need to see/visualize the data/request that are coming to eventHub.

Answer 1

Hi Tahami Rizwan •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you want to enable Azure SQL Managed Instance drop/deletion event logs.

I assume you have looked into this document https://learn.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-export-configure?tabs=azure-portal&view=azuresql-mi#basic-metrics which suggests to repeat these steps of diagnostic telemetry for each single and pooled database you want to monitor.

In addition to configuring diagnostic telemetry for a managed instance, you also need to configure diagnostic telemetry for each instance database.

Please check if it is already done. If done, please share configuration details of the SQL MI to further investigate.

Thanks