This assumes that log backup schedule is in place.
这里假设存在一个日志备份计划。
However, sometimes a transaction log backup is larger than a full backup.
不过，有时事务日志备份要比完全备份还大。
A pure log backup contains only transaction log records for an interval, without any bulk changes.
纯日志备份只包含某个时间段的事务日志记录，不包括任何批量更改。
Then restore the latest clean database backup and the subsequent log backups, including the one taken in above step.
然后还原最近的干净的数据库备份和随后的日志备份,包含上一步做的日志备份.
The log backup does not prevent truncation, but the head of the log cannot move until the log backup completes.
在日志备份完成之后，日志头部才能移动。在这种情况下，释放空间可能需要再进行一次日志备份。
The start of the transaction is recorded in the first transaction log backup, but the end of the transaction is recorded in the second transaction log backup.
该事务的起点记录在第一个事务日志备份中，终点记录在第二个事务日志备份中。
As of SQL Server 2005, we have page level restore, meaning that we can restore only the damaged pages (instead of a full backup) and then the subsequent log backups.
如果是SQLServer 2005，我们拥有页级别的还原，意味着我们能够只还原损坏的页面(代替完整的备份)然后是随后的日志备份。
Transaction log backup — Backs up all of the transactions performed against the database after the last successful full backup or transaction log backup is completed.
事务日志备份——备份所有执行的事务日志(在上次完全备份之后执行的)。
If you managed to backup log in above step, then you will most probably have zero dataloss.
如果你在上一步做了日志备份,那么你很可能会没有数据损失.
备份日志。
Finally, online backup images of databases and table Spaces will include the set of log files necessary to restore and recover the backup image to a consistent point in time.
最后，数据库和表空间的在线备份镜像将包括一组日志文件，在将备份镜像恢复到某个一致的时间点时，这些文件是必需的。
For example, to recover data to the end of business day Wednesday, you would need the delta backup images for Monday, Tuesday, and Wednesday (or Wednesday's log files).
例如，为了将数据恢复到星期三工作结束时，需要星期一、星期二和星期三的差异备份镜像(或星期三的日志文件)。
For example, the log buffer writes each transaction to logs and how different log mode can be used to accomplished different modes of backup and recovery.
例如，日志缓冲区将每个事务写到日志，可以使用不同的日志模式来实现不同的备份和恢复模式。
Then if a system or media failure occurs, you can use the transaction log and a third-party backup utility to recover your database.
如果系统或媒体发生失败，您可以使用事务日志和第三方备份实用工具恢复数据库。
The second restores to the most recent state, using a combination of full backup plus rolling forward the transaction log, called rollforward recovery.
另一种机制通过使用全备份，并前滚事务日志，使数据库恢复到最近的状态，这种机制也叫前滚恢复。
For example, total log space consumed since the last backup could trigger an automatic backup.
例如，自上次备份以来所消耗的总日志空间可以触发一个自动的备份。
You can easily configure your system to automatically backup a log file when it is full.
可以轻松地配置系统，使之在日志文件被写满时自动备份日志文件。
Ensure that you have enough logical log space configured to prevent a log full condition during your quarterly backup.
应确保配置了足够多的逻辑日志空间，以防在进行每季度的备份时出现日志已满的状况。
For online backup (using archive logging), the threshold of the log space used is triggered.
对于在线备份(使用存档日志)，达到使用的日志空间的阈值。
Should you desire to do an online backup (which you will explore later), log mode needs to be modified to archived logging.
如果要进行在线备份，那么需要将日志模式改为存档日志。
RECOVER will do the RESTORE of the most recent backup, followed by a log apply process to bring the table space or database to a specified point in time.
RECOVER会恢复最近的备份，然后执行一个日志应用进程，将表空间或数据库带到一个指定的数据点。
Includes a high-availability data replication (HDR) feature for disaster recovery and continuous log restore, point-time instance-wide restore, and table-level backup and recovery.
内含高可用性资料抄写 (HDR)功能，以便提供灾难回复与连续记录还原、时间点实例层面还原、表格层次备份及回复。
This results in the backup of the queue files being slightly out of sync from the backup of the log files, and the possibility that one or more of the files will be corrupted.
结果就是队列文件的备份与日志文件的备份存在些许的不同步现象，可能会有一个或多个文件被破坏。
However, you can backup these logical log files for restore purposes.
然而，可以对这些逻辑文件进行备份以用于日后恢复。
S3 storage is used for storing backup images and log archives for long retention periods.
S3存储用来长期保存备份镜像和日志档案。
By default, the transaction log will be copied back to the same location that it was in, when the backup image was taken.
默认情况下，事务日志将被复制回当初备份时所在位置。
Perform online backups every 2 weeks (2 weeks = 2 (weeks) * 7 (days) * 24 (hours) = 336 hours) OR if there is not at least 1 backup OR if the log space consumed is greater than 1000 * 4KB.
每两周（2 周 = 2（周） *7（天）*24（小时）= 336 小时）或不少于1 个备份时或所使用的日志空间大于 1000 *4KB 时，执行在线备份。
Restore log file option restores the log files saved in the backup image (more applicable for online backup and restore).
恢复日志文件选项恢复备份映像中保存的日志文件(适用于在线备份和恢复)。
All transaction log files after the backup.
备份之后的所有事务日志文件。
All transaction log files after the backup.
备份之后的所有事务日志文件。
应用推荐