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.
SQL SERVER – Steps to Generate Windows Cluster Log?
When a SQL Server resource will not come online in a failover cluster, I check the cluster log. Here are the steps to generate the cluster log on Windows.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – WARNING – SQL Server Has Encountered N Occurrence(s) of I/O Requests Taking Longer Than 15 Seconds
Seeing ‘I/O requests taking longer than 15 seconds’ in the ERRORLOG? Here is what this common warning means and where to look for the slow disk behind it.