For this, you need to keep a log; bulk load and import programs often log to a file, but inside the database you need to use a table.
为此，需要维护一个日志；批量装载和导入程序常常将日志写入一个文件，但是在数据库中需要使用一个表。
Think of the access log of a web server where the IP address and browser agent are repeated in every row, taking up space but simplifying bulk processing.
想一想web服务器的访问日志，其中每一行都重复了IP地址和浏览器代理，这虽然占用了空间但却简化了批量处理。
As with bulk loads from a file, therefore, it is better to issue a COMMIT statement periodically, so the logical log files can be flushed.
因此，在从文件进行批量装载时，最好是定期发出commit语句，这样就可以刷新逻辑日志文件。
Under the full recovery model or bulk-logged recovery model, if the transaction log has not been backed up recently, backup might be what is preventing log truncation.
在完整恢复模式或大容量日志恢复模式下，如果最近尚未备份事务日志，则请立即进行备份以免发生日志截断。
A pure log backup contains only transaction log records for an interval, without any bulk changes.
纯日志备份只包含某个时间段的事务日志记录，不包括任何批量更改。
A pure log backup contains only transaction log records for an interval, without any bulk changes.
纯日志备份只包含某个时间段的事务日志记录，不包括任何批量更改。
应用推荐