Forum Discussion
ADX Cluster Backups
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...
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()