The SQL Server engine logs to the /var/opt/mssql/log/errorlog file in both the Linux and Docker installations. You need to be in ‘superuser’ mode to browse this directory.

How do I view database logs in Linux?

Use the following commands to see log files: Linux logs can be viewed with the command cd/var/log, then by typing the command ls to see the logs stored under this directory. One of the most important logs to view is the syslog, which logs everything but auth-related messages.

How do I view SQL logs?

View Log Files

1. In Object Explorer, expand Management.
2. Do either of the following: Right-click SQL Server Logs, point to View, and then click either SQL Server Log or SQL Server and Windows Log. Expand SQL Server Logs, right-click any log file, and then click View SQL Server Log. You can also double-click any log file.

14 мар. 2017 г.