Sign inSign up

awlpublic/sqlserver-backup

By awlpublic

•Updated almost 3 years ago

Backup Microsoft SQL Server databases to S3 and Local path (supports periodic backups).

Image
0

2.1K

awlpublic/sqlserver-backup repository overview

⁠sqlserver-backup

Backup Microsoft SQL Server databases to S3 and Local path (supports periodic backups). Based on the mssql-scripter package (https://github.com/microsoft/mssql-scripter⁠), forked from: https://github.com/msshapira/mssql-scripter⁠

⁠Usage

Docker:

$ docker run -e S3_ACCESS_KEY_ID=key -e S3_SECRET_ACCESS_KEY=secret -e S3_BUCKET=my-bucket -e S3_PREFIX=backup -e MSSQL_DATABASE=dbname -e MSSQL_USER=user -e MSSQL_PASSWORD=password -e MSSQL_HOST=localhost awlpublic/sqlserver-backup

Docker Compose:

mssql-backup:
  image: awlpublic/sqlserver-backup
  environment:
    SCHEDULE: '@daily'
    S3_REGION: region
    S3_ACCESS_KEY_ID: key
    S3_SECRET_ACCESS_KEY: secret
    S3_BUCKET: my-bucket
    S3_PREFIX: backup
    MSSQL_DATABASE: dbname
    MSSQL_USER: user
    MSSQL_PASSWORD: password
    MSSQL_EXTRA_OPTS: '--schema=public --blobs'
    ENABLE_BACKUP_TO_S3: 'yes'
    ENABLE_BACKUP_TO_LOCAL: 'no'
    PUSH_URL: ''
⁠Automatic Periodic Backups

You can additionally set the SCHEDULE environment variable like -e SCHEDULE="@daily" to run the backup automatically.

More information about the scheduling can be found here⁠.

⁠Push URL (>= Version 1.1)

You can push a check URL (for example StatusCake) to handle alerting.

Tag summary

Content type

Image

Digest

sha256:65e42d3ff…

Size

390.6 MB

Last updated

almost 3 years ago

docker pull awlpublic/sqlserver-backup