Home Forums Article Discussions Article Discussions by Author Discuss content posted by Krishna Full Transaction log RE: Full Transaction log

  • March 18, 2009 at 4:47 am

    #961706

    jts_2003 (3/18/2009)

    Hi Krishna

    Very clear article, but I was a bit confused about the first option of shrinking the log - if it is full now, won't shrinkign the physical size mean it is still full afterwards?

    John

    Hello John,

    Thanks for your valuable feedback. When you shrink the log file it removes the inactive VLF's to reuse the space made available.