SQL Server bulk-logged recovery differs from other log-based recovery methods because it does not include log entries for changes that cause large log entries.

Question

Quizplus · Accepted Answer

SQL Server bulk-logged recovery mode only logs minimal information for certain bulk operations, such as bulk inserts or index rebuilds, resulting in smaller log entries and faster recovery times. Other log-based recovery methods, such as full and simple recovery, may log more information for every transaction.

SQL Server Bulk-Logged Recovery Differs from Other Log-Based Recovery Methods