tail-log backup 中文意思是什麼
tail-log backup
解釋
尾日誌備份-
If the database is offline and does not start. try to take a tail - log backup. because no transactions can occur at this time, using with norecovery is optional
如果數據庫包含要備份的、在記錄間隔期間執行的大容量日誌更改,則僅在所有數據文件都存在且未損壞的情況下,尾日誌備份才會成功。 -
A tail - log backup is taken after a failure in order to prevent work loss and can contain either pure log or bulk log data
在發生故障后提取尾日誌備份,以防止工作丟失,該備份中可以包含純日誌數據也可以包含批量日誌數據。 -
Norecovery takes the database into the restoring state. this guarantees that the database does not change after the tail - log backup. the log is truncated unless the no truncate option or copy only option is also specified,
當需要對某個文件執行離線還原以便與數據庫匹配時,或按照計劃故障轉移到日誌傳送備用服務器並希望切換回來時,會用到此操作。 -
Norecovery is useful when failing over to a secondary database or when saving the tail of the log before a restore operation. to perform a best - effort log backup that skips log truncation and then take the database into the restoring state atomically, use the no truncate and norecovery options together
在完整恢復模式或大容量日誌恢復模式下,使用文件和文件組備份恢復數據庫時,還需要從一個或多個日誌備份(使用backup log創建)中還原事務日誌。 -
If the tail - log backup succeeds, you can avoid any work loss by restoring the database up to the point of failure
如果尾日誌備份成功,則可以通過將數據庫還原到故障點來避免任何工作丟失。 -
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子句,否則,還原數據庫而不先備份日誌尾部將導致錯誤。 -
If a tail - log backup has incomplete metadata, in the
如果尾日誌備份包含不完整的元數據, -
If the metadata in a tail - log backup is incomplete, the
表中的每一行對應備份時的一個文件組。 -
This occurs again for the 9 : 45 p. m. transaction tail - log backup
對晚上9 : 45的事務尾日誌備份再執行一次上述操作。 -
If the tail - log backup succeeds, removing mirroring may be your best alternative
如果尾日誌備份成功,停止會話可能是最佳選擇。 -
Create a tail - log backup of the currently active transaction log as of the point of failure
失敗時創建當前活動事務日誌的尾日誌備份。 -
A log backup taken of the tail of the log just before a restore operation is called a tail - log backup
可捕獲尚未備份的日誌(日誌尾部) ,是恢復計劃中的最後一個相關備份。 -
Table will be missing most of the information about filegroups at the time of the tail - log backup. most of the
但是,如果尾日誌備份中的元數據不完整,會丟失與文件組有關的大部分信息。 -
However, typically you will want to restore the subsequent log backups, in sequence, ending with the tail - log backup, if any. therefore, before you start to restore a database, you must create a tail - log backup
如果有兩個或兩個以上必須在邏輯上保持一致的完整恢復模式數據庫,則可能需要執行特殊步驟,以確保這些數據庫的可恢復性。
分享友人