ADX Cluster Backups

[data_channa]

Hi All,

I would like to know the best strategy to backup the Kusto Database? I come from a traditional SQl server background - trying to understand where and how i back up - for disaster recovery

thanks!

[#2]

Got an answer from MS Support on this one - that i will share for anyone else wondering about this. 

using the .export feature of ADX we can export the cluster tables to the data lake as a "backup" strategy. 

[#3]

Stumbled on this recently and even though it's an old thread I thought I'd point to this official documentation: Azure Data Explorer and business continuity disaster recovery - Azure Data Explorer | Microsoft Lear...

[#4]

data backup:
I am using two mechanims to backup my data for different use cases:
1. continous export

.create-or-alter continuous-export MyExport
over (T)
to table ExternalBlob
with
(intervalBetweenRuns=1h, 
 forcedLatency=10m, 
 sizeLimit=104857600)
<| T

2. manual daily export via Azure Data Factory 

.export async to table external_mytable <| mytable

My experience is that the second one works better for very large tables (>100.000.000.000 rows) while the first one is ideal for smaller ones.

metadata backup:
In addition I am exporting the functions and policies via ADF once a day

 .set-or-append function_history <| .show functions |extend timstamp = now()