• Again, thanks for all the nice and encouraging comments. I have now decided to continue with the series. Sorry for those who did not like it and would rather not see it continue; based on the feedback so far, you are in the minority.

    SanDroid (11/16/2011)


    The main thing this question is missing is if the DB was created with FULL or BULK as the option for logging.

    How exactly is that relevant for the answer? No errors due to a full log are possible, as the log file is specified to be "sufficently large".

    Some of your statements contradict ones the articles they reference.

    Ouch, that is a very embarassing mistake. Can you please elaborate on which of my statements you mean, and which articles they contradict? I thought I checked everything very carefully; if I was wrong, I'd like to know before I start working on the next similar question.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/