if you’re using sqlite, you can write to a backup database too on a separate usb drive or e.g a NFS mount

https://docs.corelightning.org/docs/advanced-db-backup