Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have simple recovery mode. Problem is that transaction log file is not shrinked automatically, current size on the disk is 250Gb, at the same time i can manually shrink it to 1MB. The same behaviour i can see for other databases with simple recovery mode.
DBCC LogInfo show me status = 0 for all VLF.
Because that's the way it works. Changing to the Simple Recovery Model doesn't do shrinks because shrinks of the log file are generally a bad idea. Using auto-shrink is one of the worst ideas ever because whatever made it grow before is going to cause it to grow again and growing the log file is an arduous task for SQL Server because it has to format the growth with VLFs (Virtual log files).
What you need to do is figure out what's causing it to grow before you do any shrinking. My odds-on "favorite' for what's causing it to grow is people that follow the supposed "Best Practice" Index Maintenance that most of the world has been stuck on for more than 2 decades. It's not actually a "Best Practice", was never meant to be a "Best Practice" and is actually a very worst practice in almost all cases (I say "almost" but I've not yet found a case where it works well).
So, find out what's causing your log file to grow (it might be something other than "Index Maintenance" in the form of bad code) and fix it. Only then consider shrinking your log file.
Whatever you do, don't turn on auto-shrink. Don't even think about it. It just isn't worth it.