Hi Signoz Team, I have some questions according to backup of Signoz. We are for the moment only using metrics. Please refer to links in your documentation according below if you have more information there. About Signoz.db-file: • What exactly does this sqlite-file include? More than user data, dashboards, alerts, email channels? • How should you take backup of the sqlite-file? According to this SQLite Backup API there are alternatives which seems to be better than backing up via the file system. What are your thoughts? • What about restore - any tips regarding this how you should restore? • Are there any general recommendations how often and when you should take backup? Of course, your activity affects how often you should do it but could you give some general recommendations here? About Clickhouse DB: • What are the recommendations according how take backup of the Clickhouse DB etc? Do you have any documentation about this? Thanks in advance, Emma

Hey @Emma Johannesson, About Signoz.db-file: • It contains metadata as you rightly mentioned •

sqlite3 /var/lib/signoz/signoz.db .dump

should be enough for a backup. • The dump file is essentially a list of sql commands which can be easily restored • Once a day should be the first iteration. Then you can reduce if necessary. About Clickhouse DB: • Something like this https://github.com/SigNoz/charts/pull/329