Indeed there is. Finally. Now that I decided to switch to MySQL (which brings - „other“ types of issues 
) I recently found
- this Database corruption after full restore - is this “normal” still? - #12 by tom_l
- and therefore this Allow to lock SQLite database during backup by agners · Pull Request #60874 · home-assistant/core · GitHub
…which should at least make the SQLite based recorder DB more robust (of course not in all cases like power loss etc. - but at least being able to safely restore a DB backup! Unbelievable, backups able to be restored, let’s call it 2022 
)