Category 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 -
DBA Myths: CHECKDB runs on startup.
2September 16, 2019 by Kenneth Fisher
If you look at your error log you’ll (hopefully) see entries like this shortly after the instance startup: CHECKDB for …
Continue reading -
I’ve gotten a transaction log full error but when I look it’s not full??
2April 16, 2018 by Kenneth Fisher
Every now and again I’ll get an error telling me a transaction log is full. This can be for any …
Continue reading -
What’s the difference between Files and Filegroups?
2March 28, 2018 by Kenneth Fisher
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct …
Continue reading -
Why shouldn’t I shrink my database log file?
10May 15, 2017 by Kenneth Fisher
TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
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 -
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 -
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.
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 