Forum Discussion

data_channa's avatar
data_channa
Copper Contributor
Oct 07, 2020

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

 

thanks!

 

 

 

 

3 Replies

  • wernerzirkel's avatar
    wernerzirkel
    Brass Contributor
    Dec 11, 2023

    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()
  • data_channa's avatar
    data_channa
    Copper Contributor
    Oct 12, 2020

    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. 

Resources