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