it's not single transaction file. But in period of time the log file is going on increasing.
My concern is even after backup strategy i need to shrink the file monthly twice which i won't want to do very regularly.
As said if it increasing for single transaction then it would better option to resize the log file.
So need your help where i can set any option where the log file will re-use the inactive portions. so that i will not run any shrink cmmd.
-Sanath