• jeff.mason (7/20/2012)


    Steve Jones - SSC Editor (7/20/2012)


    There was a slight typo in the original question, and I mistakenly added another in fixing it. It should have been:

    12:10 AM - Transaction 1 on QotDDatabase begins

    12:11 AM - Transaction 2 on QotDDatabase begins

    12:12 AM - Transaction 2 on QotDDatabase commits

    12:13 AM - Transaction 1 on QotDDatabase commits

    12:14 AM - Full backup data reading of QotDDatabase begins

    12:15 AM - Transaction 3 on QotDDatabase begins

    12:16 AM - Transaction 3 on QotDDatabase commits

    12:17 AM - Full backup data reading of QotDDatabase ends

    12:19 AM - Transaction 4 on QotDDatabase begins

    12:20 AM - Full backup of QotDDatabase ends

    12:21 AM - Transaction 4 on QotDDatabase commits

    In this case, 1, 2, and 3 are included, 4 is not as it starts after the data reading portion of the backup ends. I'll award back points to people since it was confusing.

    Sorry to be pedantic, Steve, to make sure -- you mean transaction 4 starts at 12:19, right?

    Yes, this whole thing makes my head hurt. Too hard to edit this and not make a mistake somewhere.