Remotely backup SQL Server Docker container Using Powershell

Question

I have a SQL Server on a docker container (microsoft/mssql-server-linux) I want to Backup the database remotely using Powershell command.

So The final result will be that a .bak file would be added to the container. Does anyone knows if it is possible, and how?

Mehdi Akbarian Rastaghi · Answer 1 · 2018-11-11T21:40:09.320

1

yes! microsoft/mssql-server-linux is based on ubuntu 16.04 and its possible to use scp from inside container to your host!use docker exec -it {container_id} bash to access your container terminal! after creating .bak file with this guid:

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-backup-and-restore-database?view=sql-server-2017

the file is inside your container!use scp to copy over ssh!

here is a hint about how to scp from linux to windows: https://stackoverflow.com/a/37712656/4708874

edited Nov 11 '18 at 21:40

answered Nov 08 '18 at 16:18

Mehdi Akbarian Rastaghi

485
6
26

Can I use backup command without getting bash access to inside of the container, my goal is to use rest request to the listening sql container, to backup. – Dan The Man Nov 11 '18 at 09:26
I am getting the following "bash: mysqldump: command not found" – Dan The Man Nov 11 '18 at 10:07
for the first comment, you can but you need to write a web service or you can use an open source project here: https://github.com/arut/nginx-mysql-module – Mehdi Akbarian Rastaghi Nov 11 '18 at 21:22
mysql != mssql. As such, I wouldn't expect a backup command for the former to work on the latter. – Ben Thul Nov 11 '18 at 21:27
oh sorry!these days I work on different projects with different RDBMS and I mixed them up! I edited my answer thank you @BenThul – Mehdi Akbarian Rastaghi Nov 11 '18 at 21:44

score 0 · Answer 2 · answered Nov 11 '18 at 21:50

Backing up the database should work no differently just because the SQL Server is running in a container. That is, issuing a backup database [yourDB] to disk = '«some file path»'; will work. Now, whether that file path is internal to the container or external (i.e. you are using a persistent volume) depends on how you started the docker instance.

Remotely backup SQL Server Docker container Using Powershell

2 Answers2