Best Practice for backing-up local database

[jberry02]

@kenkendk

@jberry02

Is there an accepted “best practice” for backing up the local Duplicati sqlite database?

I know some Duplicati users do make a backup of the local database.
I think they will usually have an additional backup that takes care of databases, and then schedule it to run a few minutes after the primary backup.

This is basically what I was considering.

@kenkendk

The design of Duplicati is such that the local database is not needed, so from a design perspective, you should not have to do so.

In the past, there has been complaints that the recreate database was really slow, and in some cases failed, requiring the use of the recovery tool to get data out.

From another post:

@jberry02

@ts678

Did it wind up reading all the dblock files (ouch)?

Given that it took:

 Start 2025-04-01 14:52:13 End 2025-04-03 16:26:17 

(i.e. 2 days and 1.5 hours) I’m pretty sure it downloaded all of the files.

IIRC this is about how long it took on the first failed attempt as well, although this time the end result is MUCH better.

So the database recreate was really slow, and the clean-up has resulted in issues that have not yet been solved.

@kenkendk

Happily corrected, but I do not believe any of these concerns are valid anymore.

As a user, I consider these concerns to still be valid.