Tag Archives: Log File

  1. Changing to simple recovery to clear the log.

    3

    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

    1

    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

    2

    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.

    2

    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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,245 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013