A client asked about DBCC TRACEON and DBCC TRACEOFF messages in the ERRORLOG. Here is what they mean, using trace flag 1222 for deadlock logging as an example.
SQL SERVER – Finding If Status of Bulk Logging Enabled or Not From Logs
A friend’s SSIS jobs switch a database to Bulk-Logged and back again. Here is how to find which of his log backups ran with Bulk Logging Enabled.
SQL SERVER – Error 15559 – Error 912 – Script Level Upgrade for Database ‘master’ Failed
SQL SERVER – Error 15559 – Error 912 – Script Level Upgrade for Database ‘master’ Failed. Let us fix the error in this blog.
SQL SERVER – Starting Up Database – Why Multiple Times in Errorlog?
My instance took unusually long to come up, and the ERRORLOG showed ‘Starting up database’ many times for the same database. Here is why that happens.
SQL SERVER – FIX Error 18456, Severity: 14, State: 6. Login failed for user
A reader hit Error 18456, Severity: 14, State: 6 while logging in. Here is what state 6 means and how to fix this login failed error.
SQL SERVER – FIX Error 18456, Severity: 14, State: 58. Login failed for user
Login failed for user with state 58? Newer SQL Server versions give better details in the ERRORLOG. Here is how to FIX Error 18456 when you see this state.
Tracking sp_configure Changes Through Error Log Messages
Someone changed a setting and nobody admits it. Here is what the SQL Server error log keeps, and what it never records.