• Alternatively, change the recovery model to bulk logged just before the load and back on completion thereof.

    however, this will require a full backup before and after. a log backup before and after is recommended.

    Bulk logged reduces log space usage by using minimal logging for most bulk operations.

    see Prerequisites for Minimal Logging in Bulk Import for more information in this regard

    good question, thanks Craig

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”