Hi there,
This is what I have:
- I installed Windows 10 and on it I installed MSSQL 2022 Eval
- In installed Ubuntu 22.04 and on it I installed MinIO latest [via Docker]
What I’mm trying to do:
- Backup MSSQL 2022 from Windows machine to MinIO from Ubuntu machine
What I did:
- MinIO is over https [self sign certificates as both machines are locally, virtualized]
Run these commands for Backup [NOTE: the commands are run from a sql docker container from Ubuntu machine]:
1.
QUERY=$(echo "CREATE CREDENTIAL [s3://10.5.5.10:9000/sql] WITH IDENTITY = 'S3 Access Key', SECRET = 'user:pass';")
sqlcmd -S 10.5.5.11,1433 -U sa -Q "$QUERY" -P 'S0methingS@Str0ng!'
QUERY=$(echo "BACKUP DATABASE DBTest TO URL = 's3://10.5.5.10:9000/sql/DBTest.bak' WITH COMPRESSION, STATS = 10, FORMAT, INIT;")
sqlcmd -S localhost,1433 -U sa -Q $QUERY -P 'S0methingS@Str0ng!'
The error that I’m receiving is this:
Cannot open backup device 's3://10.5.5.10:9000/sql/DBTest.bak'. Operating system error 12175(failed to retrieve text for this error. Reason: 317).
Msg 3013, Level 16, State 1, Server DESKTOP-5CSDK6A, Line 1
BACKUP DATABASE is terminating abnormally.