Detection: SQL Database Deleted
Overview
Detect when an Azure SQL database was deleted. SQL databases store critical application and business data, and their deletion can lead to significant data loss and service disruptions. Monitoring these deletions helps ensure data availability and prevents unauthorized or accidental removal of vital databases.
References:
Usage
Run the detection in your terminal:
powerpipe detection run azure_activity_log_detections.detection.sql_database_deletedSnapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe detection run azure_activity_log_detections.detection.sql_database_deleted --shareSQL
This detection uses a named query:
select tp_timestamp as timestamp,operation_name as operation,resource_id as resource,caller as actor,tp_index::varchar as subscription_id,resource_group_name as resource_group,tp_id as source_id,status as event_status,*
from azure_activity_logwhere operation_name = 'Microsoft.Sql/servers/databases/delete' and status = 'Succeeded'
order by timestamp desc;