Page Comparison

...

In this section you will find the process for backing up the MSSQL DB that is running inside a docker container for the Lakehouse MonitorOptimizer.

1. Stop the containers

First and foremost you’ll need to stop the app and the database:

...

This tells you that the Lakehouse monitor Optimizer and the DB are down.

2. Locate the MSSQL data

...

# tar zcvf ~centos/mssql-backup.tgz .
./
./.system/
./.system/system/
./.system/system/Temp/
./.system/system/lsasetup.log
....

Note: in my script above I have saved the tgz file in the centos home folder, as such: ~centos/mssql-backup.tgz

...

In this section you will find the process for using the backup created in the first section to restore the MSSQL DB that’s running inside a docker container for the Lakehouse MonitorOptimizer.

Assumptions

I’m assuming that you have the mssql-backup.tgz file on your server under the centos user home folder, if not, you need to use scp to copy it from your local machine, so on your local machine you run this:

...

This tells you that the Lakehouse monitor Optimizer and the DB are down.

2. Locate the MSSQL data

...