您要查找的是不是:
- The simple recovery model risks significant work-loss exposure if the database is damaged. 如果資料庫損壞,則簡單恢復模式將面臨極大的工作丟失風險。
- If you need to remove the log backup chain from a database, switch to the simple recovery model. 如果需要從資料庫刪除日誌備份鏈,請切換到簡單恢復模式。
- If you switch from the full or bulk-logged recovery model to the simple recovery model, you break the backup log chain. 如果從完整恢復模式或大容量日誌恢復模式切換到簡單恢復模式,則需要中斷備份日誌鏈。
- Under the simple recovery model, the database cannot be restored to a specific point in time within a specific backup. 在簡單恢復模式下,資料庫不能還原到特定備份中的特定時間點。
- Under the simple recovery model, this assumes that the data has been changed to read-only since the full backup. 在簡單恢復模式下,此備份假定自完整備份之後已經將數據更改為只讀。
- Therefore, under the simple recovery model, the backup intervals should be short enough to prevent the loss of significant amounts of data. 因此,在簡單恢復模式下,備份間隔應儘可能短,以防止大量丟失數據。
- For a database that uses the simple recovery model, we recommend that you take a full or differential backup after the bulk-import operation finishes. 對於使用簡單恢復模式的資料庫,建議在大容量導入操作後進行完全或差異備份。
- You cannot roll forward across recovery model changes that involve the simple recovery model, because the log chain is broken. 由於日誌鏈已斷開,因此無法在涉及簡單恢復模式的恢復模式切換中前滾。
- This topic provides a summation of the basic BACKUP statements for each of the backup types supported by the simple recovery model. 本主題總結了簡單恢復模式支持的每種備份類型的基本BACKUP語句。
- BCM pages are not relevant in a database that is using the simple recovery model, because no bulk logged operations are logged. 在使用簡單恢復模式的資料庫中,BCM頁是不相關的,因為大容量日誌記錄操作不記入日誌。
- Incorporated the restore scenario overviews from the former "Restore Scenarios Under the Simple Recovery Model" and "Restore Scenarios Under the Full Recovery Model" topics. 合併了以前「簡單恢復模式下的還原方案」和「完整恢復模式下的還原方案」主題下的還原方案概述。
- The primary database must use the full or bulk-logged recovery model; switching the database to simple recovery will cause log shipping to stop functioning. 主資料庫必須使用完整恢復模式或大容量日誌恢復模式,將資料庫切換為簡單恢復模式會導致日誌傳送停止工作。
- However, the simple recovery model is sometimes appropriate for a small production database, especially if it is mostly or completely read-only, or for a data warehouse. 但簡單恢復模式有時也適合小型生產資料庫(尤其是當其大部分或完全為只讀時)或數據倉庫使用。
- The simple recovery model risks significant work-loss exposure if the database is damaged. Data is recoverable only to the most recent backup of the lost data. 由於未備份事務日誌,因此,如果資料庫損壞,則簡單恢復模式將面臨極大的工作丟失風險。
- This topic identifies the operations that are minimally logged under the bulk-logged recovery model (as well as under the simple recovery model) but fully logged under the full recovery model. 本主題介紹在大容量日誌恢復模式下(以及簡單恢復模式下)按最小方式記錄,但在完整恢復模式下完整記錄的操作。
- A new log chain starts either with the first full database backup following database creation or after switching from the simple recovery model to the full or bulk-logged recovery model. 新的日誌鏈將隨資料庫創建后的第一個完整資料庫備份而啟動,或在從簡單恢復模式切換到完整或大容量日誌恢復模式后啟動。
- Example: Online Restore of a Read-Only File (Simple Recovery Model) 示例:在線還原只讀文件(簡單恢復模式)
- Example: Piecemeal Restore of Database Simple Recovery Model 簡單恢復模式對段落還原的影響
- Example: Piecemeal Restore of Only Some Filegroups (Simple Recovery Model) 示例:僅對某些文件組進行段落還原(簡單恢復模式)
- After some time, change the recovery model to full. 一段時間后,將恢復模式更改為完整恢復模式。