Database/MS SQL Server
[SQL Server] How to change MSSQL Server data folder on Linux
HoZang
2023. 3. 8. 15:33
[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