• OK, you're joking right??

    Firstly, TRUNCATEONLY does not apply to T-log files!

    A wholesale shrink of all log files on the instance, and you believe this will be beneficial?

    What do you do for an encore, shrink the data files then rebuild the indexes?

    Incidentally, Do you carry out index maintenance on your SQL Server instance?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉