Burası değil daha ayrıntılı bilgi veren event log veya app log olması gerekiyor onun dışında errorlog bölümünde bulabilirsiniz.
Örnek dizin olarak C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLLog dizinine bakıp dosyayı iletirseniz bakalım.
2021-08-09 11:59:34.12 Server UTC adjustment: 3:00
2021-08-09 11:59:34.12 Server (c) Microsoft Corporation.
2021-08-09 11:59:34.12 Server All rights reserved.
2021-08-09 11:59:34.12 Server Server process ID is 8292.
2021-08-09 11:59:34.12 Server System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R730'.
2021-08-09 11:59:34.12 Server Authentication mode is MIXED.
2021-08-09 11:59:34.12 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLLogERRORLOG'.
2021-08-09 11:59:34.12 Server The service account is '***ERP$'. This is an informational message; no user action is required.
2021-08-09 11:59:34.12 Server Registry startup parameters:
-d C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAmaster.mdf
-e C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLLogERRORLOG
-l C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAmastlog.ldf
2021-08-09 11:59:34.12 Server Command Line Startup Parameters:
-s "MSSQLSERVER"
2021-08-09 11:59:34.61 Server Error: 17113, Severity: 16, State: 1.
2021-08-09 11:59:34.61 Server Error 2(The system cannot find the file specified.) occurred while opening file 'C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAmaster.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.
2021-08-09 11:59:34.61 Server SQL Server shutdown has been initiated