Can I take a copy (backup) of the database that is in HA

The Last 2 updates of core os - has give problem - and the restore had to be and older one - so I lost 10 day of statistic
I run HA on a virtual - Proxmox - that also demands upgrade almost every day

What kind of DB is it

thanks in advance

John

Check in System / repairs / system information (click the three dots on the right to access) and scroll down to see your database type.

You know you can initiate a manual backup from the Backup screen in the settings / system screen.

Does Proxmox also support snapshots?

If you already are running Proxmox, make use of either taking snapshots before upgrades, over even better do proper backup Proxmox Backup Server

It's an SQLite DB. You can stop home assistant via the command line and copy the home-assistant_v2.db file in your config folder.

thanks Tom - that the info I needet

regards
John