Tag Archives: error log
-
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 -
How do I look at my error log if SQL won’t open?
1October 22, 2018 by Kenneth Fisher
Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you …
Continue reading -
Misleading errors: “Server is configured for Windows authentication only.” But it’s not!
6June 18, 2018 by Kenneth Fisher
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just …
Continue reading -
Updated query to view data in the error log
5May 31, 2018 by Kenneth Fisher
This is one of my favorite scripts. It pulls all of the data from the error log and dumps it …
Continue reading -
Help it takes forever to open the SQL Server Log!
Leave a commentJanuary 24, 2018 by Kenneth Fisher
Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the …
Continue reading
SQL Studies 