bulk-logged recovery model 中文意思是什麼
bulk-logged recovery model
解釋
大容量日誌恢復模式-
Like the full recovery model, the bulk - logged recovery model retains transaction log records until after they are backed up
與完整恢復模式相同,大容量日誌恢復模式也將事務日誌記錄保留到對其備份完畢為止。 -
The databases in a log shipping configuration must use the full recovery model or bulk - logged recovery model
日誌傳送配置中的數據庫必須使用完整恢復模式或大容量日誌恢復模式。 -
Backup under the bulk - logged recovery model
數據備份的類型(完整恢復模式) -
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
從簡單恢復模式切換到完整模式之後,建議您:立即執行完整數據庫備份或差異數據庫備份。 -
How the bulk - logged recovery model works
大容量日誌恢復模式的工作原理 -
When to use the bulk - logged recovery model
何時使用大容量日誌恢復模式 -
Restore under the bulk - logged recovery model
在完整恢復模式下備份 -
Switching from the full or bulk - logged recovery model
>從完整恢復模式或大容量日誌恢復模式切換 -
For more information about bulk - logged recovery model, see
有關大容量日誌恢復模式的詳細信息,請參閱 -
For more information about the bulk - logged recovery model, see
有關大容量日誌恢復模式的詳細信息,請參閱 -
Under the full recovery model or bulk - logged recovery model, regular
本節的相關信息簡單恢復模式下的備份 -
Backup under the full recovery model backup under the bulk - logged recovery model
其他時間都應使用完整恢復模式。 -
Under the bulk - logged recovery model, if a log backup contains bulk - logged changes, point - in - time recovery is not possible to a point within that backup
完成恢復時,數據庫的時間由主文件所恢復到的時間點決定。 -
The tradeoffs are bigger log backups and increased work - loss exposure because the bulk - logged recovery model does not support point - in - time recovery
由於大容量日誌恢復模式不支持時點恢復,因此必須在增大日誌備份與增加工作丟失風險之間進行權衡。 -
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語句。 -
Compared to the full recovery model, which fully logs all transactions, the bulk - logged recovery model minimally logs bulk operations, although fully logging other transactions
與完整恢復模式(完全記錄所有事務)相反,大容量日誌恢復模式只對大容量操作進行最小記錄(盡管會完全記錄其他事務) 。 -
Recovery models for system databases switching from the full or bulk - logged recovery model
從完整恢復模式或大容量日誌恢復模式切換 -
Under the full recovery model or bulk - logged recovery model, conventional backups also include sequential transaction log backups
對于完整模式數據庫或大容量日誌模式數據庫,還必須執行事務日誌備份。 -
However, for a production database, the best choice is typically the full recovery model, optionally, supplemented by the bulk - logged recovery model
若要為數據庫選擇最佳恢復模式,需要考慮包括數據庫大小、結構以及數據庫恢復目標和要求在內的諸多因素。
分享友人