Reply to post:

"it was discovered the database back up had not been working properly over the past 12 months."

What backups? If they're not regularly tested they're not backups and clearly they hadn't been tested.