I tried creating a backup of a and sqk database on mssql that is within a docker container.
here is the log
| 8/9/2021 3:56:06 PM | [Info] | Starting job "Backup Job - 1 " - “Full”. Server “ROBII9”. Account “SYSTEM@WORKGROUP”. App v.“12.5.13”. |
|---|---|---|
| 8/9/2021 3:56:07 PM | [Info] | Connecting to: SQL RTM Developer Edition (64-bit). localhost. |
| 8/9/2021 3:56:07 PM | [Info] | The backup folder “/var/opt/mssql/data” has “647.263GB” free space. The temporary folder “C:\Windows\TEMP\SYSTEM\Pranas.NET\SBF\424dadd6-403c-4721-ba29-51a857fe179d” has “647.263GB” free space. |
| 8/9/2021 3:56:07 PM | [Info] | Backing up “localhost” SQL Server databases. |
| 8/9/2021 3:56:07 PM | [Info] | Backing up “testsx” with “Full” backup type. |
| 8/9/2021 3:56:07 PM | [Error] | Failed to backup “testsx” database with “Full” backup type: Backup media not found: “/var/opt/mssql/data\testsx202108091556.bak”. |
| 8/9/2021 3:56:07 PM | [Info] | Cleaning up backups of "Backup Job - 1 " job. |
| 8/9/2021 3:56:07 PM | [Error] | Job "Backup Job - 1 " finished with “1” errors. |
I did go into the containere and notice that the backup file is there,
but here it does not seem to find it, I think it’s because the file / is a backslash , but maybe I’m mistaken.
Is there anyway to have SQLBackupandFTP work with with sql server on a docker container?
Best Regards…