• You need to run the following on that database and post the results here:

    DBCC CHECKDB({your database}) WITH all_errormsgs, no_infomsgs;

    What you posted before does not show the errors and we need to see all of the errors to determine what needs to be done. I would start by identifying a clean backup and start getting prepared to restore from that backup. In most cases, the easiest and best way to recover from an integrity problem is to restore.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs