Category Archives: Log File

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

  2. Playing with the log – Before the first full backup

    1

    October 29, 2014 by Kenneth Fisher

    The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
    Continue reading

  3. Does SQL Server do a CHECKDB during an instance restart?

    11

    May 7, 2014 by Kenneth Fisher

    When you start up an instance do you rely on the CHECKDB entry in the error log of SQL Server …
    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

Follow

Get every new post delivered to your Inbox.

Join 526 other followers