• Erin Stellato (3/28/2013)


    Transaction log backup sizes should be about the same size whether you're in FULL or BULK LOGGED recovery...

    http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2830-bulk_logged-recovery-model/

    The article is more geared towards debunking the myth that BULK LOGGED recovery will reduce the size of the backups. The comment "roughly the same size" is ancillary to the point.

    Because there is more information being written to the log backup when BULK LOGGED operations are present than there would be when the logged activity was all carried out while in FULL recovery mode, namely the extent allocation log entries plus the data itself, the log backups will be larger in BULK LOGGED than in FULL for the same set of operations.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato