In the Azure Portal, SQL Databases have a “Restore” feature, which will create a new database from a restore a backup/restore point.
Suppose I have an Azure SQL Database named “Contoso” and over the past 12 months I’ve used the “Restore” feature described above to restore a copy of Contoso several times. After each restore, the newly restored database was deleted within a few days.
How would I generate a list of all the times I conducted a restore of the Contoso database? Or all the times I’ve conducted a restore in general?
I’ve tried looking for a Azure CLI command or Log analytics query but keep finding results on listing restore points, rather than restore actions.