Hello, I accidentally clear the table data by using the command: clear table [tableName] data. Is it possible to recover data? Thanks a lot!

Hello @Jing Ou , Thanks for the ask and using the Microsoft Q&A platform . If the table's effective retention policy has 'Recoverability' set to 'Enabled', and less than 14 days have passed – it should be possible. To do so, you will have to work with the Microsoft support team .. Please do let me know how it goes . Thanks Himanshu Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Recover data in Azure Data Explorer

Accepted answer

HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-03-31T15:05:50.907+00:00

Hello @Jing Ou ,
Thanks for the ask and using the Microsoft Q&A platform .

If the table's effective retention policy has 'Recoverability' set to 'Enabled', and less than 14 days have passed – it should be possible.

To do so, you will have to work with the Microsoft support team ..

Please do let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Please sign in to rate this answer.
HimanshuSinha-msft 19,376 Reputation points Microsoft Employee

2021-04-01T23:02:44.667+00:00

Hello @Jing Ou ,,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
Thanks
Himanshu

Jing Ou 46 Reputation points

2021-04-02T02:27:13.557+00:00

Thank you for your reply. I just found downstream data to help recover my data, and it solved my problem. Back to the question itself, I asked kusto team about it . They told me as you said, first set retention policy with Recoverability with Enabled, then open a support request (https://aka.ms/kustosupport). I haven't tried it yet, but it seems that it is a auto-reply chatbot which helps you recover data.

Thanks,
Jing Ou

Jing Ou 46 Reputation points

2021-04-02T03:18:55.717+00:00

I tried and finally the chatbot will help create a ticket to kusto team and they will help recover data.
Sign in to comment

Recover data in Azure Data Explorer

0 additional answers