December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...