as always "it depends"
here, for VMs with MSSQL, DBs ~2G, I only rely on Proxmox Backup Server as MSSQL VSS writer ensures consistency. Hookscript not required.
For some VMs, DATA and DBs backups are done within guest, only system vdisk is backup by Proxmox others vdisks are excluded.
Proxmox...