[SQL Server] How to change MSSQL Server data folder on Linux

[SQL Server] How to change MSSQL Server data folder on Linux

 

# stop the mssql server service
systemctl stop mssql-server

# make your own new mssql data folder and log folder
mkdir /home/mssql/data
mkdir /home/mssql/log

# check the mssql binary path
ls /opt/mssql/bin

# change the mssql data folder
sudo /opt/mssql/bin/mssql-conf set filelocation.defaultdatadir /home/mssql/data

# change the mssql log folder
sudo /opt/mssql/bin/mssql-conf set filelocation.defaultlogdir /home/mssql/log

#copy all file in the default data and log folder to your own new data and log folder
sudo cp -r /var/opt/mssql/data/* /home/mssql/data
sudo cp -r /var/opt/mssql/log/* /home/mssql/log

#change ownership of data and log files
sudo chown -R /home/mssql

#restart the mssql server service
systemctl start mssql-server