Additionally , transaction log marks are necessary if you need to recover a set of related databases to a logically consistent state 另外,若要将一组相关数据库恢复到逻辑上一致的状态,必须使用事务日志标记。
Write updates that insert or append new data are minimally logged if the database recovery model is set to bulk - logged or simple 如果将数据库恢复模式设置为大容量日志模式或简单模式,则对插入或追加新数据的
However , if the database is damaged or lost when bulk logging is in effect , you cannot recover the database to the point of failure 不过,如果在大容量日志记录执行时数据库损坏或丢失,则无法将数据库恢复到故障点。
A complete recovery is a recovery that involves rolling forward the logs to bring the database to the most current time with no lost of data 完全恢复是包括将数据库恢复到最近时间的前滚日志并且没有数据丢失的恢复。
Also , if the source database later becomes damaged , you can revert the source database to the state it was in when the snapshot was created 而且,如果以后源数据库损坏了,便可以将源数据库恢复到它在创建快照时的状态。
Therefore , we strongly recommend that you back up the log immediately before switching , which allows you to recover the database up to that point 因此,极力建议您在切换之前备份日志,这样可允许您将数据库恢复到该点。
However , if a user error occurs in an online database , you can revert the database to a database snapshot that predates the error 但是,如果在联机数据库中发生用户错误,则可以将数据库恢复到发生错误之前的数据库快照。
If the database is , consider using the full recovery model . this lets you use log backups to recover the database to a specific point in time 如果是,则考虑使用完整恢复模式,通过它可以使用日志备份将数据库恢复到特定的时点。
The full recovery model allows a database to be recovered to the point of failure , assuming that the tail of the log can be backed up after the failure 如果能够在出现故障后备份日志尾部,则可以使用完整恢复模式将数据库恢复到故障点。
Also , in the event of a user error on a source database , you can revert the source database to the state it was in when the snapshot was created 快照可用于报表。另外,如果源数据库出现用户错误,还可将源数据库恢复到创建快照时的状态。