So I have a log file which grows very large after I run an SSIS job daily, sometimes up to 1220MB. In my database options I have set my recovery model to "FULL".
When it is to FULL and I perfrom shrink -> log -> it doesnt reduce much but If I set recovery model to simple it reduces it to 1 MB.
The problem is as I see it I need to leave it at full so my back ups have full version of the database.
Now I created a maintenance plan to shrink database, but im noticing it also almost doing no shrinking again because I guess recovery model is at full. How can I get a maintenance plan working which will actually reduce the log file ?