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.
SQL SERVER – Where is ERRORLOG? Various Ways to Find ERRORLOG Location
When readers report a strange error, I first ask for the SQL Server ERRORLOG. Here are the various ways to find the ERRORLOG Location on your server.
Building the Restore Script for the Latest Backup Chain From msdb
Do not type a restore sequence by hand at 2 AM. Let msdb tell you the order, and prove the script works before you need it.
SQL SERVER – How to Increase Number of Errorlog Files
An audit needed 30 days of ERRORLOG, but a nightly recycle job kept only a few files. Here is how to increase the number of errorlog files in SQL Server.
Data Files and Log Files: What Each One Does in SQL Server
Data Files and Log Files are the two kinds of file every SQL Server database needs. This post explains what lives in each, why the log is written first, and how to list both with a query on sys.database_files.