Tag Archives: Log File

  1. Has this login been used recently?


    April 8, 2020 by Kenneth Fisher

    I get asked this every now and again, along with the companion When was the last time this login was …
    Continue reading

  2. 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

  3. 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

  4. How to remove additional (unwanted) log files


    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

  5. 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

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013