For SQL Server 2017 RTM, the fourth cumulative update was released on 20th February, and it is available for download at the Microsoft Downloads site . It brought a couple of significant improvements like;
In this blog, I am going to discuss the tip configuring new errorlogfile location on SQL Server on Linux. Let’s follow the below steps to accomplish the relocation of errorlogfile;
SELECT SERVERPROPERTY('ErrorLogFileName') AS 'Error log file location'
Syntax : sudo mkdir /var/newerror (It will create the directory newmas)
Syntax : ls -l
Syntax : sudo chown mssql /var/newerror (It changes the user ownership)
Syntax : sudo chgrp mssql /var/newerror (It changes the group user ownership)
Syntax : /opt/mssql/bin/mssql-conf set filelocation.errorlogfile /var/newerror/ errorlog
Syntax : sudo systemctl stop mssql-server
Syntax : sudo systemctl start mssql-serverSyntax
: sudo systemctl status mssql-server
With the execution of the last step, you have successfully set-up new Errorlogfile location for SQL Server on Linux machine.