log chain 中文意思是什麼

log chain 解釋
日誌鏈
  • log : n 1 原木，圓木，乾材。2 測程儀，計程儀。3 航海日誌，（飛行員用的）航海日誌；旅行日記。4 〈英國〉...
  • chain : n 1 鏈子，鏈條；項圈；表鏈。2 連鎖；連續，一系列，一連串；（山）脈。3 〈常 pl 〉鐐銬；羈絆，拘束...
  1. If you recover the database after restoring one of the intermediate transaction log backups, that before the end of the log chain, you cannot restore the database past that point without restarting the complete restore sequence, starting with the full database backup

    如果要在還原其中一個中間事務日誌備份之後恢復數據庫，則在日誌鏈結束之前，除非從完整數據庫備份開始重新啟動整個還原順序，否則，將無法還原該點之前的數據庫。最好的做法就是在恢復數據庫之前還原所有的事務日誌，然後再另行恢復數據庫。
  2. A log chain starts with a full backup of the database

    日誌鏈以完整數據庫備份開始。
  3. A continuous sequence of log backups is called a log chain

    連續的日誌序列稱為「日誌鏈」
  4. Log chain a continuous sequence of transaction logs for a database

    日誌鏈中的點，恢復過程中前滾在該點停止。
  5. Discusses the most important log sequence numbers for creating a log chain

    討論了用於創建日誌鏈的最重要的日誌序列號。
  6. If you switch from the full or bulk - logged recovery model to the simple recovery model, you break the backup log chain

    如果從完整恢復模式或大容量日誌恢復模式切換到簡單恢復模式，則需要中斷備份日誌鏈。
  7. We recommend that you never use no log or truncate only to manually truncate the transaction log, because this breaks the log chain

    盡管可用此選項手動截斷事務日誌，但是極力建議您不要這樣做，因為這會將日誌鏈斷開。
  8. If a transaction log backup in this log chain is lost or damaged, you can restore only transaction logs before the missing transaction log

    如果此事務日誌鏈中的事務日誌備份丟失或損壞，則您只能還原丟失的事務日誌之前的事務日誌。
  9. The database mirroring synchronous mode guarantees that the log chain is unaffected by a mirroring failover and that only valid log is restored

    數據庫鏡像同步模式可以保證日誌鏈不受鏡像故障轉移的影響，也可以保證只還原有效的日誌。
  10. Immediately after you complete the switch to the full recovery model or bulk - logged recovery model, take a full or differential database backup to start the log chain

    從簡單恢復模式切換到完整模式之後，建議您：立即執行完整數據庫備份或差異數據庫備份。
  11. The copy - only log backup has no effect on the log chain, and other log backups behave as if the copy - only backup does not exist. for more information, see

    在進行完整數據庫備份或差異備份時， sql server會備份足夠的事務日誌，確保還原數據庫時生成一個一致的數據庫。
  12. Sql server 2005 usually requires that you take a tail - log backup before you start to restore a database. the tail - log backup prevents work loss and keeps the log chain intact

    除非restore語句包含with replace或with stopat子句，否則，還原數據庫而不先備份日誌尾部將導致錯誤。
  13. These options remove the inactive part of the log without making a backup copy of it, and truncate the log by discarding all but the active log. this breaks the log chain

    這些選項通過放棄活動日誌以外的所有日誌，無需製作日誌的備份副本即可刪除不活動的日誌部分，並中斷日誌鏈。
  14. These options break the log chain, because they remove the inactive part of the log without making a backup copy of it and truncate the log by discarding all but the active log

    例外情況是如果檢查點發生在backup語句仍活動時，則不截斷日誌。有關自動檢查點間隔的詳細信息，請參閱
  15. This alternative points out the redundant security offered by maintaining a chain of transaction log backups across a series of full database backups

    此備選過程指出了冗餘安全性，該安全性通過維護一系列完整數據庫備份中的事務日誌鏈備份來獲得。
分享友人
分享到 Line

分享到臉書