I have a Kusto database with the following retention policy:
{
"SoftDeletePeriod": "30.00:00:00",
"Recoverability": "Enabled"
}
Yesterday some data was removed from a table in the database since it was over 30 days old.
According to the retention policy docs, if the Recoverability attribute is set, "If set to Enabled, the data will be recoverable for 14 days after it's been soft-deleted."
My question is what is the query I execute to recover the soft-deleted data that has been lost?
I’m guessing it’s something like:
.<name-of-command> table <tableName>;? Maybe there’s an option somewhere to specify just how many days to recover? How do I recover soft-deleted data that is retained by the Recoverability=enabled set?
>Solution :
Such a recovery currently requires opening a support ticket, via the Azure portal:
