The bulk-logged recovery model minimally logs bulk operations, although fully logging other transactions. The bulk-logged recovery model protects against media failure and, for bulk operations(bcp,BULK INSERT,SELECT INTO), provides the best performance and least log space usage.
[SQL Server]大容量日志恢复模式bulk_logged recovery model
最新推荐文章于 2021-05-10 09:22:34 发布
本文介绍了SQL Server的大容量日志恢复模式,该模式在保障媒体故障防护的同时,提供大容量操作的最佳性能和最小日志空间使用。然而,这也增加了数据丢失风险,因为大容量操作无法按事务还原。 BCM(Bulk Changed Map)跟踪由大容量操作修改的范围,只有详细记录数据页的日志备份才能确保恢复。
摘要由CSDN通过智能技术生成