Snapshot not working cannot backup

Looking to create Manged Backup, but it's creating incomplete backups of size 7MB, the site is bigger than the backup size.

Increased max_memory_limit, server resources but the issue still exists. Please check the chat notes for more info.