The bulk-logged recovery model is similar to full recovery, but it differs in the way that bulk operations are captured in the transaction log. With full recovery mode, SQL Server writes every row to the transaction log including those rows that are inserted with bulk import operations. Bulk import operations include
BULK INSERT. The
CREATE INDEX, and
ALTER INDEX can also be bulk import operations when certain conditions are met.
In contrast, bulk-logged recovery only keeps track of the extents that have been modified by a bulk load operation but does not write each row to the transaction log; this is also referred to as minimal logging. This reduces the overall size of the transaction log during bulk ...