Assuming we back up as depicted above sunday full backup , monday to saturday we do incremental backups 假定我们像上面描述的那样执行了备份星期天执行完全备份,星期一至星期六执行增量备份。
After completing an initial backup , any subsequent jobs only require the resources needed for an incremental backup 在完成了第一次备份之后,任何接续的工作只需要给一次渐近式备份所需要的资源。
Cumulative incremental backup on the other hand , backs up all the blocks used since the most recent backup at level n - 1 or lower 另一方面,累积增量备份将备份自最近在级别n - 1或更低级别上进行备份以后使用的所有数据块。
Applying a level - 0 - backup and then incremental backups will be much faster than having to rollforward through a large range of logical logs 先应用level - 0 - backup ,然后再进行增量备份,这将比通过大量逻辑日志进行前滚更快。
If you want to perform both types of back - ups , complete the steps two times ; one time for the full backup , and one time for the incremental backup 如果要执行这两种类型的备份,必须将本过程中的各步骤执行两次:一次用于完全备份,另一次用于增量备份。
After setting this parameter to " yes " , you must take a full database backup in order to have a baseline against which incremental backups can be taken 在将该参数设置为“ yes ”之后,您必须执行完全数据库备份,以便在可以采用哪些增量备份上有一个基线。
To restore without losing data , you will restore from the first sunday backup , followed by incremental backup taken on saturday and roll forward 要进行恢复,而又不丢失数据,那么您需要从第一个星期天备份恢复,然后恢复星期六取得的增量备份并进行前滚。
In the case of a failure for example on saturday after the incremental backup is taken , you can just restore the first sunday full backup and apply the incremental on saturday 在备份失败的情况下,例如,在执行了增量备份后的星期六,您只可以恢复第一个星期天的完全备份,并应用星期六的增量备份。
When this parameter is set to " yes " , the database manager tracks database modifications so that the backup utility can detect which subsets of the database pages must be examined by an incremental backup and potentially included in the backup image 在将该参数设置为“ yes ”时,数据库管理器就会跟踪数据库修改,这样,备份实用程序就能够检测数据库页面的哪些子集必须由增量备份负责检查,以及备份映像中可能包括哪些子集。
An incremental backup is one that provides a backup of files that have changed or are new since the last incremental backup;Description of Full, Incremental, and Differential Backups. Microsoft Support.