• SQL Kiwi (9/11/2012)


    The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and a point.

    http://msdn.microsoft.com/en-us/library/dd425070.aspx (Summarizing Minimal Logging Conditions)

    Thanks to Ravi for the question, and Paul for the amplification.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn