• Hello,

    As your database is in the full recovery mode, the transaction log will not be truncated unless you perform a transaction log backup. When you backup the log, the log is truncated (bear in mind that this does not mean that the file will be shrunk).

    The correct backup strategy really does depend on the individual database, how often is it updated? How much data can you afford to lose in the event of corruption?

    Andrew