I have had issues with the database getting corrupted several times in the last 5 years and lost all my data. Each time it renamed the database file and created a new one. I am not familiar with databases and had no way to fix it (I tried finding help from the community but it was beyond my skill level).
It would be nice if HA could fix the database or just delete the section that is corrupt if that would be possible… that would be an awesome stability improvement for HA!