• Transaction log is a critical component of the database system, if there is a system failure, the transaction log might be required to bring back the database to a consistent state.

    Every transaction which is made in the database is logged in the transaction log for recovery/rollback purpose. So, it is not possible to stop logging any specific transaction(s).

    You can truncate the table instead of deleting the rows, truncate operation is minimally logged when compared to delete operation. This helps you keeping your Tlog size small.

    Regards,
    Ravi.