SQL Server On Linux: Logger.ini Size and Rollover Additions to SQL Server 2019 CU4


Moved from: bobsql.com


I can’t take credit for this post as Dylan added the code and provided the write-up to share with you.  All I did was a bit of editing and proof reading, enjoy.


For SQL Server on Linux, there are additional logging capabilities. These can be vital in debugging issues like AD authentication. The internal logs are configured using /var/opt/mssql/logger.ini text file and can be configured to write to standard out or files. For example, the logger.ini below will turn on logging for Kerberos and LDAP errors and write them to /var/opt/mssql/log/security.log.