• There are 3 pages damaged (27:59906941, 27:59906942, 27:59906943)

    Dropping the table should work as it will deallocate those pages. However if you have a clean backup and an unbroken chain of log backups, doing a page restore of those 4 pages should be a lot faster and, if you have Enterprise Edition, the restore will be an online operation.

    Do you have the required backups?

    Edit: corrected, 3 pages not 4.

    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