Relocate Master Database and Log Files to Replicated Storage

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

*The following steps should be carried out on node-a AND node-b.


There are some additional steps that need to be done in between. Please review the summary of the overall steps in Protecting MSSQL Using Quick Service Protection.

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.