So far the following tasks have been completed:
- Created the database on node-a
- Switched over the datarep-datakeeper resource to node-b
In step 1, the information about the newly created mssql database was created in /var/opt/mssql/mssql.conf.
Now we will create the same mssql database on node-b so the information about the mssql database will be stored on node-b in /var/opt/mssql/mssql.conf. The database files themselves are located in /datakeeper/mssql/.
On node-b, these files can be seen as shown below:
Rename these folders so that the database can be created successfully on node-b.