This post is inspired from a discussion about bulk logged recovery model and log backup. Some basics: In bulk logged recovery model, some operations can be minimally logged, like: SELECT INTO Index create, rebuild and drop Bulk loading of data The interesting Read More...