Home Forums Programming General Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system? RE: Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

  • In SIMPLE recovery model, SQL Server still logs all transactions, but will minimally log certain bulk operations; in effect, the level of logging is the same as that applied in BULK_LOGGED model.

    So that answers your question if there is a point in changing recovery model.

    I would try to split your operations into smaller transactions but only if the log is really growing to unreasonable sizes.