您要查找的是不是：
- 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. 一段时间后,将恢复模式更改为完整恢复模式。
