• winmansoft (1/15/2013)


    But shrinking the log file will increase fragmentation ryt?

    No.

    So is it good habit to shrink the log file?

    Not regularly, no.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass