Jeff,  your knowledge on the subjet are impressive.  Thanks a lot for your time, very instructive but difficult for me to know what I should do now!

the index optimization...

OK I have found what makes the log grow; it's our weekly index optimization job.  Before the job the log was 3gb  after the job the log is 39gb  (with...

Yes the other job I have checked runs daily while the biggest job runs once a week

Limit size of jib history is checked
Maximum job history log size...

Thank you very much

Thanks again, y

I shrunk the log file with Management Studio as shown in the link you provide.  It goes down a bit

January 15, 2019 at 10:21 am

#2018953

Thanks for your help,  I really need some help.  I really appreciate your reply.

DBCC SQLPERF(LOGSPACE)
Result :
Log Size(MB): 34077.49
Log space used (%): 4.790907
Status: 0

Autogrow has...