• Raghavender Chavva - Monday, April 16, 2018 9:06 AM

    Now My question is why I am not able to shrink the log file after 1st log backup even though 98% free space is there. Why I am able to shrink the log file after n number of log backups.

    Most likely because the active portion of the log was at the end of the file, and NOTHING may move log records around in a log file. At a later point, the log had looped around and the active portion was at the beginning of the file, meaning the empty space at the end could be trunctated.

    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