• You are correct. There is no need to run a daily job that shrinks the file, just to see it grow again after few hours. Nothing will be gained and the only thing that will happen is that it will grow again, some operations will have to wait for the log to grow and the number of VLFs will also grow.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/