• Be careful with this command in production as you 'break' the log chain if in full or bulk logged recovery models.
    You can still use it specifying WITH COPY_ONLY though.