Do you have any other Databases, Like the InFlux db, I am currently backing up 2.4gb Snapshots. My HA Log file is under control, I have to figure how to off load my Influx db to a NAS drive. So I don’t have to save it in a snapshot.
Oh, and you should switch to a USB SSD drive. You will be amazed with the boost in speed, well worth the Upgrade. And the SSD does not have to be large, I’m using an 80gb SSD.
Are you sure it is actually the database that is growing? Home Assistant is infamous for bloating the storage with logs that are NOT possible to control in a good way.
Maybe this one is of interest:
TL;DR
There are a lot of log files. Some of them grows towards infinity. Some people claim this is not a problem, and/or they are not growing since there is a cap. Others show how their logs grow above the cap.