However, sometimes a transaction log backup is larger than a full backup.
不过,有时事务日志备份要比完全备份还大。
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.
该事务的起点记录在第一个事务日志备份中,终点记录在第二个事务日志备份中。
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.
事务日志备份——备份所有执行的事务日志(在上次完全备份之后执行的)。
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.
另一种机制通过使用全备份,并前滚事务日志,使数据库恢复到最近的状态,这种机制也叫前滚恢复。
By default, the transaction log will be copied back to the same location that it was in, when the backup image was taken.
默认情况下,事务日志将被复制回当初备份时所在位置。
All transaction log files after the backup.
备份之后的所有事务日志文件。
Listing 4: Restoring the salesdb database from a backup and placing the transaction log in different location.
清单4:从备份恢复salesdb数据库并将事务日志放在不同的位置。
Listing 7: Perform a backup, enable the transaction log archive mode, and delete archived transaction logs before this backup.
清单7:执行备份,启用事务日志归档模式,并删除这次备份之前归档的事务日志。
Listing 6: Perform a backup, enable the transaction log archive mode, and preserve archived transaction logs before this backup.
清单6:执行备份,启用事务日志归档模式,并保存这次备份之前归档的事务日志。
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.
在完整恢复模式或大容量日志恢复模式下,如果最近尚未备份事务日志,则请立即进行备份以免发生日志截断。
A pure log backup contains only transaction log records for an interval, without any bulk changes.
纯日志备份只包含某个时间段的事务日志记录,不包括任何批量更改。
A full backup includes part of the transaction log so that you can recover the full backup.
完全备份包括一部分事务日志,以便可以恢复完全备份。
A full backup includes part of the transaction log so that you can recover the full backup.
完全备份包括一部分事务日志,以便可以恢复完全备份。
应用推荐