July 12, 2018 at 7:30 am
Hi All,
I'm tinkering with SQL Server 2017 on linux. I need to have master database on a LVM mount, but I can't seem to update the default location for master device. I wonder if this is due to me running developer edition?
When I try to set the master data directory with opt/mssql/bin/mssql-conf set filelocation.masterdatafile /xxxfilepath/
I get:
The setting 'filelocation.masterdatafile' is not supported.
Also during build, when I pass the MSSQL_MASTER_DATA_FILE config to opt/mssql/bin/mssql-conf setup, it doesn't complain and builds the server, but still puts master in the default location: /var/opt/mssql/data/master.mdf
July 12, 2018 at 2:18 pm
Just an update from my side. I updated to CU8, base on below support case. And now filelocation.masterdatafile works. However the setting 'filelocation.mastlogfile' is still not supported.
July 13, 2018 at 7:09 am
Figured out the mastlog.ldf move as well. There is a typo in their documentation.
filelocation.mastlogfile should be filelocation.masterlogfile << master not mast.
July 16, 2018 at 5:29 pm
mvanderwal 71223 - Friday, July 13, 2018 7:09 AMFigured out the mastlog.ldf move as well. There is a typo in their documentation.filelocation.mastlogfile should be filelocation.masterlogfile << master not mast.
Thank you very much for posting all the updates along the way. It's very helpful when someone else finds this thread when searching on the same issue. I think we've all gotten bit on searches and where it's just the same question as ours. Or it has a few things to try and the original poster never posts back.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply