Bulk-Logged Recovery
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 BCP and BULK INSERT. The SELECT INTO, 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 ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
