pallid tide
I used an automation to set up full backups (including the database) to a network drive on a schedule using the native backup action (Home Assistant Supervisor 'Create a full backup'), which seems to be working fine.
However, I've read a lot of posts in various forums about the database in full backups getting corrupted when there happens to be an active transaction when the backup is run. I haven't seen as many complaints about it in the last couple years though, so I'm not sure if this has been resolved or if everyone just knows how to work around it now.
Is the database corruption risk a solved issue at this point? If not, is there a best practice for setting up automated database backups in a more robust way?
I'm not sure whether this is helpful information or not, but I'm running Home Assistant OS on a Raspberry Pi 4.
atomic mountain