• You right click the database in question and script it out. There is an advanced tab and in there you can have it create the indexes and keys as well. You would want to run the script to create the database without data. I did not include the indexes when I did it but I do not think that will be a problem. You may have to give the database a new name in the script as two with the same name could be a problem.

    Once you rin the script you have a copy of the original database but no data.

    Next you right click and export the data into the new database. As the data loads new Index allocation Map files are generated.

    Run dbcheck against the new database.

    select your row counts in the two databases to ensure all the data came over.

    Create a backup of the new database.

    Restore the corrupt database from the new database backup.

    Run dbcheck again and you should be good to go.

    This is the only way I could figure out to fix the problem.