Any idea why the backup is not running for me?

[myriad007]

I've added the backup to my mssql container but I am having trouble getting the backup to initiate. Here is my docker compose file:

version: "3.3"
services:
  server:
    environment:
      - ACCEPT_EULA=Y
      - TZ=America/Toronto
      - MSSQL_SA_PASSWORD=xx%xx&2jLr
      - MSSQL_PID=Express
      - MSSQL_BACKUP_DIR=/var/opt/mssql/backup
      - shm-size 1g
    ports:
      - 1433:1433
    volumes:
      - /mnt/data/mssql/data:/var/opt/mssql/data
      - /mnt/data/mssql/log:/var/opt/mssql/log
      - /mnt/data/mssql/secrets:/var/opt/mssql/secrets
      - /mnt/data/mssql/backup:/var/opt/mssql/backup
    container_name: sqlpreview
    hostname: sqlpreview
    image: mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04
    user: root
    restart: unless-stopped
  backup:
    image: bbtsoftwareag/mssql-backup
    # for using the cleanup feature, use the backup volume from db.
    volumes:
      - /mnt/data/mssql/backup:/var/opt/mssql/backup
    environment:
      - TZ=America/Toronto
      - DB_SERVER=sqlpreview
      - DB_USER=SA
      - DB_PASSWORD=xx%xx&2jLr
      - DB_NAMES=school2021_1
      - BACKUP_AGE=7
      - BACKUP_CLEANUP=true
      - PACK=tar
      - CRON_SCHEDULE=02 9 27 10 *
    networks:
      - default
networks: {}

Have I made an error here? Here is some terminal output:

mssql-backup-1 | Starting cron task manager...
mssql-backup-1 | - Crontab = 02 9 27 10 *
2024-10-27 09:00:25.75 spid49s [DevOpsSnapshotTelemetryTask] Evaluating the background task.
2024-10-27 09:04:17.15 spid51 XE session 'telemetry_xevents' stopping.
2024-10-27 09:04:17.20 spid51 XE session 'telemetry_xevents' started.

I don't really know how to go about troubleshooting this issue but any advice will be gratefully received.

[christianbumann]

Hi @myriad007, quick tipp, in markdown you can format code like yaml more beautiful and readable.
https://stackoverflow.com/questions/75548339/mixing-yaml-and-markdown

Back to your issue

try to remove following

    networks:
      - default
networks: {}

or add the default network to the sql container too, and add the default network to the nerworks at bottom e.g.

version: '3.3'
services:
  server:
    ...
    networks:
      - default
 
  backup:
    ...
    networks:
      - default

networks:
  default:

for connecting to the database server, DB_SERVER=server (server is the service name) can be used instead of DB_SERVER=sqlpreview
sql preview is an additional dns entry created by hostname: sqlpreview which should not be required, but it depends your final docker-compose.yaml and demands

[myriad007]

I added the networks section as shown below. But no joy, still not backing up. Any logs that I should be looking at to help troubleshoot?

version: "3.3"
services:
mssqlserver:
environment:
- ACCEPT_EULA=Y
- TZ=America/Toronto
- MSSQL_SA_PASSWORD=xxx
- MSSQL_PID=Express
- MSSQL_BACKUP_DIR=/var/opt/mssql/backups
- shm-size 1g
ports:
- 1433:1433
volumes:
- /mnt/data/mssql/data:/var/opt/mssql/data
- /mnt/data/mssql/log:/var/opt/mssql/log
- /mnt/data/mssql/secrets:/var/opt/mssql/secrets
- /mnt/data/mssql/backups:/var/opt/mssql/backups
container_name: sqlpreview
hostname: mssqlserver
image: mcr.microsoft.com/mssql/server:2022-preview-ubuntu-22.04
networks:
- default
user: root
restart: unless-stopped
backup:
image: bbtsoftwareag/mssql-backup
# for using the cleanup feature, use the backup volume from db.
networks:
- default
volumes:
- /mnt/data/mssql/backups:/var/opt/mssql/backups
environment:
- TZ=America/Toronto
- DB_SERVER=mssqlserver
- DB_USER=SA
- DB_PASSWORD=xxx
- DB_NAMES=school2021_1
- BACKUP_AGE=7
- BACKUP_CLEANUP=true
- PACK=tar
- CRON_SCHEDULE=3 23 27 10 *
networks:
default: null

[christianbumann]

Hi @myriad007

It seems that -MSSQL_BACKUP_DIR=/var/opt/mssql/backups on the sql server container is not working (at least on my Windows machine with Docker Desktop).
The backup is still created on the `/backup' folder inside the container.

I would

# on the sql container remove
- MSSQL_BACKUP_DIR=/var/opt/mssql/backups

# on the sql container change path to
- /mnt/data/mssql/backups:/backup

# on the backup container change to this the backup path as it is the internal cleanup path (https://github.com/bbtsoftware/docker-mssql-backup/blob/bdcc13a3df1ee1776d776f8daa3143e4e3d40d03/backup.sh#L14C1-L15C1)
- /mnt/data/mssql/backups:/backup

# try to set a shorter interval for testing the cron job e.g. every 5 minutes
- CRON_SCHEDULE=*/5 * * * *

to check if both container are running

docker ps

to check the log of a container
docker logs <container id>

to enter a container
docker exec -it <container id> /bin/sh

to exit the container
exit

Tipp:
You can use e.g. the first 2 oder 3 characters from the container id - so you don't have to enter the whole id