I found SQL server is down at my work. Then I need to raise this to Microsoft to investigate problem but current account to contact them has expired. So I need to get all logs of SQL server for this investigation.
Which log has information for us to investigate?
From my research, I found 2 must gather logs as follow.
- All Windows Event Log from Event Viewer. (Application, Security and System)
- All log files are in MSSQL\LOG (such as ERRORLOG, log_xxx.trc, SQLAGENT.OUT and etc.)
Are all logs to investigate for general case when SQL server is down?
View Complete Post