O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required