I am assisting a customer to manage their SQL database. So far there are no issues except that the SQL Log file is growing at a fast rate even thought I have a mainteinace plan to backup the Transaction Log file every week.
I can help to shrink the log file manually. However, the customer would not like me to access their server regualrly just to do this task. I was thinking of using a shrink database maintainance plan but it will shrink their database file which is not what I want.
Is there a way to change the script of a maintenance plan in MS SQL 2014, I would like to change it so that log file is shrank not the database file? If not, is there a method to schedule a procedure to run on a weekly basis?
Please do not suggest setting the database server to Autoshrink the log file which has affected their operations. I am also not allowed to write a batch file to run the with the Windows scheduler as it is not an approved process.