Do you add a specific code to backup the DB with Affa or is that done elsewhere by the system?
No extra code added. The sme-server pre-backup event dumps the database/s, and Affa syncs to the archives.
SMEServer=yes
Watchdog=yes
RPMCheck=yes
RootDir=/var/affa
Include=/etc/dehydrated
Include=/etc/nagios/nrpe.cfg
Include=/usr/share/nextcloud/config/config.php
Include=/var/log/qmail
Include=/var/log/qpsmtpd
Include=/var/log/sqpsmtpd
affabox:/var/affa/prodsvr/scheduled.0/home/e-smith/db# ls -al
drwxr-x--- 2 root root 4096 Jun 26 07:15 mariadb105
drwxr-x--- 3 root root 4096 Jun 26 07:15 mysql
affabox:/var/affa/prodsvr/scheduled.0/home/e-smith/db/mariadb105# ls -al
-rw-r--r-- 1 root root 1386835 Jun 26 07:15 mysql.dump
-rw-r--r-- 1 root root 285408813 Jun 26 07:15 nextcloud.dump