• This suggestion assumes that the volume of data which you wish to retain is reasonably small.

    1. Set simple recovery mode on the host database.

    2. Run sp_rename to rename the original table.

    3. Create a new table with the original table name without indexes.

    4. INSERT INTO the empty table those rows which you with to retain.

    5. Create your indexes on the new table.

    6. Run sp_createstats or manually create your stats.

    7. Grant privileges to match those of the original table along with any constraints.

    8. Drop the original table as long as you've coded to check @@ERROR=0.

    9. Reset to your original recovery mode.