• GilaMonster (1/30/2015)


    rob.lewis 86087 (1/30/2015)


    If you have a 20gb transaction log file in simple a recovery model

    A full back up is run

    A check point is made

    The transaction log off the back of that is truncated

    The log file still remains at 20gb on disk

    If the first thing to run is a 100mb transaction it will start to fill the empty the log file as apposed to increasing it to 20.1gb?

    Yup, though the backup has nothing to do with anything in this case. A checkpoint occurs (runs regularly), the log gets truncated.

    Thank you 🙂