5 Rules of minimally Logged Operation

5 Rules of minimally Logged Bulk insert, and if any of the requirement is not met, it will not be minimally logged operation

Rule #1: Database cannot be in FULL Recovery Model

Rule #2: Backup (Full, Differential, Log Backup) can not be running while Bulk Insert happens. 

Rule #3: Table cannot be marked for Replication

Rule #4: Must be Table Locked (TABLOCK) Hint

Rule #5: Table cannot have any indexes, and the one exception is Clustered index with NO records& ORDERED inputs. 

One Exception to the rule is as following: Since SQL server 2008, If you turn on Trace Flag 610, rule #4 and rule #5 above can be bypass and still give you minimally log operation as long as execution plan decide the right execution plan are generated against SQL server. (Main Input Data are Sorted).