Tag Archives: Log File

  1. Changing to simple recovery to clear the log.


    February 10, 2016 by Kenneth Fisher

    Clearing out a full transaction log is a common problem. A quick search will find you dozens of forum entries …
    Continue reading

  2. Playing with the log – VLF order while growing the log


    December 17, 2014 by Kenneth Fisher

    The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of …
    Continue reading

  3. How to remove additional (unwanted) log files

    Leave a comment

    November 5, 2014 by Kenneth Fisher

    Using multiple data files is a common best practice for a number of reasons, but multiple log files? Typically a …
    Continue reading

  4. The effect of VLF size on shrinking the log.


    August 26, 2013 by Kenneth Fisher

    I was wondering the other day how VLF (Virtual Log File) sizes effected shrinking the log file so I decided …
    Continue reading


Get every new post delivered to your Inbox.

Join 847 other followers