• Enjoyed the article.

    Thinking over it I came to this question:

    You write: "An operation is said to be minimally-logged if all it logs are the allocation changes."

    In the case of a bulk insert this would mean either that a bulk insert can use only fresh allocation units (pages?) or that your statement must be rewritten to "logs which allocation units have been affected"

    And a second question: what exactly cannot be recovered in case of minimal logging?