Are all these files needed?

I noticed my /var/lib/duplicati directory (DUPLICATI_HOME) was getting big. Can any of these files be deleted? Are they just catalogs? There seems to be a few naming schemes here, so I don’t want to go deleting files without understanding them.

-rw------- 1 root root 2383872 Nov 17 2018 65678981706683768874.sqlite
-rw------- 1 root root 380683264 Aug 22 04:50 65816582788766818787.sqlite
-rw------- 1 root root 34816 Nov 7 2018 66908383768882828674.sqlite
-rw------- 1 root root 1842578432 Aug 21 16:52 68848085818373806984.sqlite
-rw------- 1 root root 3367936 Aug 21 22:46 68877380666879796773.sqlite
-rw------- 1 root root 72200192 Aug 21 22:43 70668383697778768566.sqlite
-rw------- 1 root root 511808512 Aug 22 06:09 72888288678176736681.sqlite
-rw------- 1 root root 2926592 Aug 22 06:00 77899081727287778383.sqlite
-rw------- 1 root root 19865600 Aug 22 05:00 78679076687771868771.sqlite
-rw------- 1 root root 4890888192 Aug 22 10:57 78867382737671698077.sqlite
-rw------- 1 root root 298890584 Aug 22 09:46 78867382737671698077.sqlite-journal
-rw------- 1 root root 88064 Nov 7 2018 79768765867775906687.backup
-rw------- 1 root root 20831232 Nov 7 2018 79768765867775906687.sqlite
-rw------- 1 root root 38912 Nov 25 2018 79838188768168678780.sqlite
-rw------- 1 root root 21305344 Nov 7 2018 79908588657883866782.sqlite
-rw------- 1 root root 34816 Nov 23 2018 82738974867185676574.sqlite
-rw------- 1 root root 23964672 Aug 22 04:52 83808882698378877669.sqlite
-rw------- 1 root root 2215936 Nov 22 2018 83858180698472818889.sqlite
-rw------- 1 root root 91505664 Mar 6 23:53 85708780877388837683.sqlite
-rw------- 1 root root 38912 Nov 24 2018 87757386748788687279.backup
-rw------- 1 root root 50176 Nov 24 2018 87757386748788687279.backup-1
-rw------- 1 root root 38912 Nov 24 2018 87757386748788687279.backup-2
-rw------- 1 root root 38912 Nov 24 2018 87757386748788687279.sqlite
-rw------- 1 root root 24179712 Aug 21 22:45 89767972716568836883.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107053115.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107053445.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107053559.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107055748.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107083627.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107085755.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107085806.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107092410.sqlite
-rw------- 1 root root 33792 Nov 7 2018 backup 20181107101608.sqlite
-rw------- 1 root root 33792 Nov 8 2018 backup 20181108024556.sqlite
-rw------- 1 root root 33792 Nov 8 2018 backup 20181108074600.sqlite
-rw------- 1 root root 33792 Nov 17 2018 backup 20181117021858.sqlite
-rw------- 1 root root 33792 Nov 17 2018 backup 20181117051109.sqlite
-rw------- 1 root root 33792 Nov 17 2018 backup 20181117054656.sqlite
-rw------- 1 root root 33792 Nov 17 2018 backup 20181117090316.sqlite
-rw------- 1 root root 33792 Nov 22 2018 backup 20181122034210.sqlite
-rw------- 1 root root 33792 Nov 23 2018 backup 20181123053643.sqlite
-rw------- 1 root root 33792 Nov 23 2018 backup 20181123054251.sqlite
-rw------- 1 root root 33792 Nov 23 2018 backup 20181123054924.sqlite
-rw------- 1 root root 33792 Nov 24 2018 backup 20181124114510.sqlite
-rw------- 1 root root 33792 Nov 24 2018 backup 20181124114536.sqlite
-rw------- 1 root root 33792 Nov 24 2018 backup 20181124114636.sqlite
-rw------- 1 root root 33792 Nov 24 2018 backup 20181124114736.sqlite
-rw------- 1 root root 33792 Nov 24 2018 backup 20181124114819.sqlite
-rw------- 1 root root 33792 Nov 24 2018 backup 20181124115524.sqlite
-rw------- 1 root root 33792 Nov 25 2018 backup 20181125095331.sqlite
-rw------- 1 root root 33792 Nov 25 2018 backup 20181125095959.sqlite
-rw------- 1 root root 33792 Nov 25 2018 backup 20181125101759.sqlite
-rw------- 1 root root 33792 Nov 27 2018 backup 20181127074845.sqlite
-rw------- 1 root root 33792 Mar 6 08:25 backup 20190306082509.sqlite
drwxr-xr-x 2 root root 4096 Nov 7 2018 control_dir_v2
-rw------- 1 root root 251904 Aug 22 10:51 Duplicati-server.sqlite

What I would do in your situation is this: open the web UI, and for each job you have, open the job on the page, and beneath it, click Database link. On this page, you find the filename of the local database for this specific job. Change the filename to something that includes letters (for example, use the job name) and the click Move existing database button. This renames the file. Return to main page and proceed to the next job. Once you have renamed the local database for all of your existing jobs, the rest you can delete – except of course the file Duplicati-server.sqlite.

1 Like

I now know the backup*.sqlite files are upgrade backup files from pre-2.0.4.5_beta to 2.0.4.5_beta. They could be deleted if you aren’t having problems. I wasn’t. It is the other files. I’m more interested. Some of these files are quire big.

Even the ones that do not begin with backup prefix may be backed-up old versions of databases. I haven’t paid attention to when exactly they appear, so cannot be 100% sure, but I know that after I renamed my job-specific databases, deleting the rest has brought me no trouble whatsoever.

@AimoE
The file timestamps say that the files are still modified so there I don’t thing they are abandoned.

I see lots of files with dates from last year in your listing.

It won’t do you any harm if you rename the databases of your existing, active backups. After that, you’ll find it easier to check what happens with the rest.