ok so at the time I opened this thread the DB was in simple mode which is weird

so I changed it to FUll mode

Did a bckup with Transaction log back

This morning we weren't able to connect to the DB

So changed the mode back to the Simple mode everything started to work

I ran your query again

and now under Log reuse wait desc came out to "nothing" for that DB

Can you make any sense out of this? 🙁

thanks again guys I really appreciate this