尾日誌備份 的英文怎麼說
中文拼音 [wěirìzhìbèibīn]
尾日誌備份
英文
tail-log backup-
For more information about tail - log backups, see
有關尾日誌備份的詳細信息,請參閱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
在發生故障后提取尾日誌備份,以防止工作丟失,該備份中可以包含純日誌數據也可以包含批量日誌數據。Use norecovery whenever you intend to continue with a restore operation on the database
創建尾日誌備份時,也可以同時使數據庫變為還原狀態。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子句,否則,還原數據庫而不先備份日誌尾部將導致錯誤。Before you can create the first log backup, you must create a full backup, such as a database backup or the first in a set of file backups
在失敗后創建尾日誌備份可以防止工作損失,並且,尾日誌備份可以包含純日誌或大容量日誌數據。If you are taking a backup that you plan to copy onto and restore from a cd - rom, specify blocksize 2048
只與backup log一起使用。備份日誌的尾部並使數據庫處于只讀和standby狀態。Tail log backups capture the tail of the log even if the database is offline, damaged, or missing data files
尾日誌備份可捕獲日誌尾部,即使數據庫離線、損壞或缺少數據文件。If a tail - log backup has incomplete metadata, in 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, if there are no log backups, a database can be restored only to the end of the most recent backup of the data
這簡化了備份和還原。但是,沒有事務日誌備份,便不可能恢復到故障點。只能還原到備份的結尾。Typically, before you restore a database, you should try to back up the tail of the log
進行尾日誌備份與進行日常的日誌備份不同。有關詳細信息,請參閱If the database is damaged, use either with continue after error or with no truncate. backup log
尾日誌備份可使用copy _ only選項獨立於定期日誌備份進行創建。After that, the transaction log can be backed up during any backup, except another log backup
尾日誌備份捕獲那些尚未備份的日誌記錄(即活動記錄) 。這稱為「日誌尾部」 。分享友人