如果达到某个阈值,考虑备份日志文件。
If a certain threshold is reached, consider backing up the logging files.
备份日志。
可以轻松地配置系统,使之在日志文件被写满时自动备份日志文件。
You can easily configure your system to automatically backup a log file when it is full.
因此,极力建议您在切换之前备份日志,这样可允许您将数据库恢复到该点。
Therefore, we strongly recommend that you back up the log immediately before switching, which allows you to recover the database up to that point.
如果能够在出现故障后备份日志尾部,则可以使用完整恢复模式将数据库恢复到故障点。
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.
备份逻辑日志一直是一个好主意,如果计划执行并行备份或想要执行指定到某一点的还原请参阅备份的类型,那么备份日志非常重要。
Backing up your logical logs is always a good idea and it is essential if you plan to do parallel backups or want to be able to perform point-in-time restores (see Type of backups).
这里假设存在一个日志备份计划。
如果事务日志用于备份,只在完全备份计划(每周一次)之前使用此开关。
If transaction logging is used for backups, use this switch only before the full backup schedule (once a week).
尝试执行一次恢复,了解所需的时间以及从哪里找到所有相关的部分,比如备份映像和日志。
Practice a restore so you know how long it takes and where to find all relevant pieces such as backup images and logs.
可以给备份副本和存档的日志分配多少存储空间?
How much storage space can be allocated for backup copies and archived logs?
换句话说,要想确保绝对没有数据损失,需要原样保存上次在线备份以来的日志。
In other words, to ensure absolute no data lost, these logs need to stay intact since the last online backup.
应该将日志包括在备份中。
安全和审计日志、备份、启动盘、档案副本、调试信息,以及很少访问的大对象。
Security and audit logs, backups, boot disks, archival copies, debugging information, rarely accessed large objects.
如果计划执行并行备份或者希望能够执行指定到某一时间点的还原,则确保定期备份逻辑日志就非常重要。
It is essential that you ensure your logical logs will be backed up regularly if you plan to do parallel backups or want be able to perform point-in-time restores.
对于在线备份(使用存档日志),达到使用的日志空间的阈值。
For online backup (using archive logging), the threshold of the log space used is triggered.
定期启用事务日志归档模式进行的在线备份,事务日志存储在一个容错磁盘上。
Online backups with transaction log archive mode enabled at regular intervals and the transaction logs are stored on a fault-tolerant disk.
如果要进行在线备份,那么需要将日志模式改为存档日志。
Should you desire to do an online backup (which you will explore later), log mode needs to be modified to archived logging.
当主系统上备份的逻辑日志可用时,可以将它们恢复到辅助系统上。
Logical logs backed up on the primary system can be restored on the secondary system as they become available.
日志是高度可配置的,为了安全和备份,日志甚至可以存储到单独的系统中。
Logging is highly configurable, and logs can even be stored on a separate system for security or backup purposes.
逻辑日志缓冲区是用来存储最后一次备份开始的逻辑日志记录的。
Logical-log buffer is used to store logical log records since last backup.
结合事务日志的备份和归档优势,事务日志可以让服务器的运行达到前所未有的顺畅。
Coupling this with the backup and archiving benefits of transaction logging, transaction logging makes your server run like it never ran before.
对于这些情况,即使使用备份-日志策略也不够理想。
So in these cases, even using the backup-plus-log strategy is flawed.
S3存储用来长期保存备份镜像和日志档案。
S3 storage is used for storing backup images and log archives for long retention periods.
应确保配置了足够多的逻辑日志空间,以防在进行每季度的备份时出现日志已满的状况。
Ensure that you have enough logical log space configured to prevent a log full condition during your quarterly backup.
结果就是队列文件的备份与日志文件的备份存在些许的不同步现象,可能会有一个或多个文件被破坏。
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.
恢复日志文件选项恢复备份映像中保存的日志文件(适用于在线备份和恢复)。
Restore log file option restores the log files saved in the backup image (more applicable for online backup and restore).
管理员的日常工作必须包括备份、日志轮转、性能度量(稍后详细讨论)、应用补丁和保护所有系统。
Daily chores must include backups, log rotation, performance measurement (more on this in a moment), patches, and safeguarding all systems.
该特性允许使用ontape和on - Bar实用程序执行逻辑日志备份的连续恢复。
This feature allows performing continuous restore of logical log backups using the ontape and ON-Bar utilities.
ontape实用程序自动生成文件名,并执行物理和日志备份。
The ontape utility generates filenames automatically and performs physical and log backups.
备份映像必须包含日志。
应用推荐