• Great! So informative with detailed scenarios.

    Worth a read.

    One more disadvantage of Bulk logged recovery model is that if there are Bulk inserts, transaction log backup contains modified extents instead of individual log records (in case of Full recovery model). Hence the size of log backup increases tremendously.