• You didnt need to detach the DB to do what you wanted.

    A simple change of the recovery model to SIMPLE then CHECKPOINT the DB then shrink the file would of been enough.

    As you have now detached and attached a single file DB, you wont be able to do this.

    Get a copy of the Accidental DBA guid in my signature and read through the High CPU chapter.