Is it good idea to change Simple Recover Model into Bulk-Logged on ETL system?

We are having an ETL process which inserts lots of data into tables. This database is set to Simple Recovery Model and the transaction log is growing a lot. I was thinking that would it help to set this database into Bulk-Logged Recovery Model? We are taking full backups on daily basis. So is there some operations which are not logged in Bulk-Logged Recovery Model compared to Simple Recovery Model?

If you log grows on ETL in simple mode it means your inserts are not minimally logged. The requirements for minimal logging are described in Operations That Can Be Minimally Logged and Prerequisites for Minimal Logging in Bulk Import:


Minimal logging requires that the target [of a INSERT BULK operation] table meets the following conditions:

• The table is not being replicated.

• Table locking is specified (using

TABLOCK).


The Data Loading Performance Guide also mentions the TF 610 effects and how it affects minimal logging.

StackExchange Database Administrators Q#13322, answer score: 2