| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
1. Backing up
In this section you will find the process for backing up the MSSQL DB that is running inside a docker container for the Lakehouse Monitor.
1. Stop the containers
First and foremost you’ll need to stop the app and the database:
...
This will copy the archive to my local computer from which point I can upload it to S3.
2. Restore
Pre-requisites
...
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 Monitor.
Assumptions
I’m assuming that you have the mssql-backup.tgz file on your server under the centos user home folder you can follow these steps to restore the backup, if not, you need to use scp to copy it from your local machine, so on your local machine you run this:
| Code Block |
|---|
$ scp <path to tar>/mssql-backup.tgz <your username>@<your server host>: |
1. Stop the containers
First and foremost you’ll need to stop the app and the database:
...