Category Archives: Log File
-
How to remove additional (unwanted) log files
Leave a commentNovember 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 -
Playing with the log – Before the first full backup
1October 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 -
Does SQL Server do a CHECKDB during an instance restart?
11May 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 -
The effect of VLF size on shrinking the log.
2August 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
