However, for a production database, the best choice is typically the full recovery model, optionally, supplemented by the bulk-logged recovery model.

• 但是,对于生产数据库,最佳选择通常是完整恢复模式,还可以选择大容量日志恢复模式作为补充。