• Dear John,
    I agree with Gail, you can restore the database from updated backup. If you do not have updated backup then, you should try a third party SQL database repair software to fix the issue.

    Good Luck!

    SQL Database Recovery Expert 🙂