簡單恢復模式 的英文怎麼說
中文拼音 [jiǎndānhuīfùmóshì]
簡單恢復模式
英文
simple recovery model- 簡 : Ⅰ形容詞(簡單) simple; simplified; brief Ⅱ動詞1 (使簡單; 簡化) simplify 2 [書面語] (選擇人才...
- 復 : Ⅰ形容詞1 (重復) repeated; double; duplicate 2 (繁復) complex; compound Ⅱ動詞1 (轉過去或轉過...
- 模 : 模名詞1. (模子) mould; pattern; matrix 2. (姓氏) a surname
- 式 : 名詞1 (樣式) type; style 2 (格式) pattern; form 3 (儀式; 典禮) ceremony; ritual 4 (自然科...
- 簡單 : 1 (不復雜) simple; uncomplicated; plain; simplicity 2 (平凡 多用否定式) commonplace; ordinary...
- 模式 : model; mode; pattern; type; schema
-
Types of data backups simple recovery model
>數據備份類型(簡單恢復模式)Example : piecemeal restore of database simple recovery model
簡單恢復模式對段落還原的影響Write updates that insert or append new data are minimally logged if the database recovery model is set to bulk - logged or simple
如果將數據庫恢復模式設置為大容量日誌模式或簡單模式,則對插入或追加新數據的Basic backup statements simple recovery model
>基本的backup語句(簡單恢復模式)Restore restrictions under the simple recovery model
簡單恢復模式下的還原方案The simple recovery model never supports page restore
簡單恢復模式從不支持頁面還原。Copy - only backups simple recovery model
>僅復制備份(簡單恢復模式)After switching to the simple recovery model
切換到簡單恢復模式之後Switching from the simple recovery model
簡單恢復模式下的還原方案Performing a complete database restore simple recovery model
執行數據庫完整還原(簡單恢復模式)Backup under the simple recovery model
>簡單恢復模式下的備份Under the simple recovery model, file and filegroup backups are available only for read - only filegroups
在簡單恢復模式下,文件和文件組備份只適用於只讀文件組。For a backup to a tape backup device, the blocksize option to affect the performance of the backup operation
在簡單恢復模式下,只允許對只讀文件組執行文件組備份。If you switch from the full or bulk - logged recovery model to the simple recovery model, you break the backup log chain
如果從完整恢復模式或大容量日誌恢復模式切換到簡單恢復模式,則需要中斷備份日誌鏈。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
從簡單恢復模式切換到完整模式之後,建議您:立即執行完整數據庫備份或差異數據庫備份。Involves logging the minimal amount of information in the transaction log that is required to recover the transaction without supporting point - in - time recovery
在簡單恢復模式下,除非在運行備份,否則可以始終使用按最小方式記錄操作。Under the full recovery model or bulk - logged recovery model, regular
本節的相關信息簡單恢復模式下的備份This makes the rolled forward data transactionally inconsistent. the recovery process opens the transaction log to identify uncommitted transactions
在簡單恢復模式下,數據和差異備份中的日誌記錄是涉及恢復數據庫的唯一日誌記錄。Under the simple recovery model, performing a checkpoint removes the inactive part of the log without making a backup copy. this truncates the log by discarding all but the active log
在簡單恢復模式下,執行檢查點將在不備份日誌的情況下刪除日誌的不活動部分,並通過放棄活動日誌以外的部分截斷日誌。Contains an introduction to restore scenarios as they are supported under the simple recovery model and the full bulk - logged recovery models, as well as a description of how restore and backup recovery work, and overviews of the restore system tables and the restore statement
概要介紹在簡單恢復模式和完整/大容量日誌恢復模式下所支持的還原方案、還原和備份恢復的工作原理以及還原系統表和restore語句。分享友人