• sknox (4/16/2012)


    I would say that since the question read "...could you see a log file bigger than usual?" the only logical answer is yes. While the bulk-logged recovery model is a feature designed to reduce log file growth, it does not constrain log file growth. Therefore you certainly could see a larger log file in some circumstances.

    However, I would also say that that does not seem to be the intent of the question. The question was poorly worded, but the explanation is correct. So, poor wording of the question has given us a "If False then True" situation -- which, if my memory of basic logic serves me properly, is still True. So much for logic.

    This is pretty much the way I looked at this question. The key word to me was could as well, which pretty much forces the answer to be yes because it is such an open-ended question. I'm thinking along the lines of Arthur C. Clarke's first law:

    When a distinguished but elderly scientist states that something is possible, he is almost certainly right. When he states that something is impossible, he is very probably wrong.