• I had a chat with an expert on this. It's not good news.

    If checkDB with repair allow data loss is not repairing these errors, it means that for some reason they are not repairable. Since you have no good backup, the only way that this can be fixed is if you script all the objects, export all the data that you can and recreate this as a new database.

    You also might want to look into your integrity check and backup jobs as they are clearly not adequate.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass