Data Base backup problems Wordpress

Hi, we urgently need a database and web hosting expert to fix a critical database failure. After restoring a backup from our host, our site is facing severe database errors, missing tables, lost user accounts, and broken plugin data. We have 14 days of backups available, but every restore point results in the same database corruption issues, even though the site was working perfectly before. From a small problem on site we did a backup from another day and now we have a lot of problems and can't solve the site like it was before. Wordpress - woocommerce What is likely causing this problem, and how can it be fixed?