Question: where are mssql logs stored?
Answer: SQL Server Error Log To view the error log, which is located in the %Program-Files%\Microsoft SQL Server\MSSQL. 1MSSQL\LOG\ERRORLOG directory, open SSMS, expand a server node, expand Management, and click SQL Server Logs.