MS SQL Server 2017 for Linux – Install to Non-Default Paths

linux

I want to install SQL Server 2017 for Linux on RHEl7.4.. but I want to use LVM to create a series of volumes for each of the important volumes.

/mssql/EBSData
/mssql/EBSLogs
blah blah blah

Is there a way to do this without mounting the volumes, symlinking the paths, then installing?

I'd assumed the installer might have had additional args/flags to change the default installation path, but doesn't seem too.

Best Answer

You can set environment variables to control this: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables. When you run the mssql-conf utility (https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-configure-mssql-conf) it will pick up these values and configure them for you.

This will allow you to change your directories:

and more.