• Best bet - drop the database and restore from backup (make space, get an external drive if necessary)

    There's no way to manually drop the damaged pages, that's what checkDB is for, but that seems to not be a workable solution at the moment.

    If you just run this, what's the output? (no reconfigure needed for setting to single user mode)

    exec sp_dboption 'ICBM', 'single_user', 'true'

    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