Transaction log for database is full, and then.

I have a job that runs and inserts millions and millions of records in tables and even if I run a "shrink database" before running the job I still get this message :

Executed as user: BLC\srvcconsqlexec. The transaction log for database 'TheDatabase' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases [SQLSTATE 42000] (Error 9002). The step failed.

How do I increase the transaction log so it can all work?

Is your job filling up the DB transaction log alone ?
Do you take regular log backup of your DB ?
What's your DB recovery model ? Full ? Simple ?

Based on the answers given to the above questions, there are different options :
- you can allow the log file to grow automatically.
It should then automatically adapt its size in order to complete the transaction
- you can plan log backup which will empty your already existing log file (free space internally)

I fixed the unlimited growth and automatic growth and every works. :king:

Thanks

TcW78