Tag Archives: Log File
-
Has this login been used recently?
10April 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 -
Changing to simple recovery to clear the log.
6February 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 -
Playing with the log – VLF order while growing the log
1December 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 -
How to remove additional (unwanted) log files
4November 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 -
The effect of VLF size on shrinking the log.
3August 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
SQL Studies 