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.
在完整恢复模式或大容量日志恢复模式下,如果最近尚未备份事务日志,则请立即进行备份以免发生日志截断。
Additional information is logged for long varchar and LOB fields in a database enabled for roll-forward recovery.
对于为了前滚恢复而在数据库中启用long varchar和LOB字段这样的附加信息,也会记录在日志中。
Similarly, updates and deletes are also logged with sufficient data needed for recovery purposes.
同样,更新和删除也会被记录,并保存足够数据用于恢复。
Similarly, updates and deletes are also logged with sufficient data needed for recovery purposes.
同样,更新和删除也会被记录,并保存足够数据用于恢复。
应用推荐