As discussed earlier, the data should be stored on the replicated file system. Therefore, we use the following locations for each component.

Items
Location
Master DataBase Files /datakeeper/mssql/data
Master Log File /datakeeper/mssql/xlog

First, create directories on node-a.

Relocate the Master database to the newly created directories with the /opt/mssql/bin/mssql-conf tool as follows:

Start the MSSQL server.

Once the database is started, you will see some files created on the folders specified earlier.

Now the instance can be stopped.

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment