Bulk Logged Recovery
Bulk Logged Recovery is a database recovery model in Microsoft SQL Server that optimizes performance for bulk operations like bulk imports or index rebuilds by minimally logging these operations, while maintaining full transaction log backups for point-in-time recovery. It balances the performance benefits of minimal logging with the ability to recover to a specific point in time, unlike the Simple recovery model which only allows recovery to the last full backup. This model is particularly useful in data warehousing or reporting scenarios where large data loads occur regularly.
Developers should use Bulk Logged Recovery when performing large-scale bulk operations in SQL Server, such as bulk inserts, SELECT INTO, or index maintenance, where minimizing log growth and improving performance is critical, but still requiring the ability to restore to a specific point in time for disaster recovery. It is ideal for environments like data warehouses or staging databases that undergo periodic bulk data loads, as it reduces log file size and I/O overhead compared to the Full recovery model, while offering more recovery flexibility than the Simple model.