MS SQL Server backup to AWS S3 bucket mounted by rclone

Help and Support
1

What is the problem you are having with rclone?

Hello All,

I have mounted a folder using rclone for AWS S3 and I want to backup a MS SQL database to this folder directly.
But, when I execute the command below:
BACKUP DATABASE mydbname TO DISK = 'C:\aws_s3\sqlbackup\mydbname.bak'

the process of backing up the database failed as following errors.
Msg 3202, Level 16, State 1, Line 1
Write on "C:\aws_s3\sqlbackup\mydbname.bak" failed: 87(The parameter is incorrect.)
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

Does anyone have any idea/solutions on how to solve this?

Thanks you very much in advance!

What is your rclone version (output from rclone version)

rclone v1.56.0

Which OS you are using and how many bits (eg Windows 7, 64 bit)

Windows Server 2019 Datacenter, 64 bit
Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)

Which cloud storage system are you using? (eg Google Drive)

Amazon S3

The command you were trying to run (eg rclone copy /tmp remote:tmp)

Paste command here
.\rclone.exe mount aws_s3:b1sqlsrv-backup c:\aws_s3\sqlbackup --vfs-cache-mode full

The rclone config contents with secrets removed.

Paste config here
[aws_s3]
type = s3
provider = AWS
env_auth = true
region = us-east-1

A log from the command with the -vv flag

Paste  log here
2

hello and welcome to the forum,

backing up a ms sql database has been discussed a number of times in the forum.

make sure the backup script works to local storage.
if that works, then try to backup to the rclone mount.

if that database is not large, i would back it up locally and rclone move it to aws.

3

Hi,

Yes, I found quite a few topic about sql backup to s3, but I could not find any solutions for my question.
Log content as below.

2021/07/30 17:18:33 DEBUG : rclone: Version "v1.56.0" starting with parameters ["C:\rclone\rclone.exe" "mount" "aws_s3:b1sqlsrv-backup" "c:\aws_s3\sqlbackup" "--vfs-cache-mode" "full" "--log-file" "c:\Temp\rclone\rclone.log" "--log-level" "DEBUG"]
2021/07/30 17:18:33 DEBUG : Creating backend with remote "aws_s3:b1sqlsrv-backup"
2021/07/30 17:18:33 DEBUG : Using config file from "C:\Users\Administrator\AppData\Roaming\rclone\rclone.conf"
2021/07/30 17:18:33 INFO : S3 bucket b1sqlsrv-backup: poll-interval is not supported by this remote
2021/07/30 17:18:33 DEBUG : vfs cache: root is "\\?\C:\Users\Administrator\AppData\Local\rclone\vfs\aws_s3\b1sqlsrv-backup"
2021/07/30 17:18:33 DEBUG : vfs cache: metadata root is "\\?\C:\Users\Administrator\AppData\Local\rclone\vfs\aws_s3\b1sqlsrv-backup"
2021/07/30 17:18:33 DEBUG : Creating backend with remote "\\?\C:\Users\Administrator\AppData\Local\rclone\vfs\aws_s3\b1sqlsrv-backup"
2021/07/30 17:18:33 DEBUG : fs cache: renaming cache item "\\?\C:\Users\Administrator\AppData\Local\rclone\vfs\aws_s3\b1sqlsrv-backup" to be canonical "//?/C:/Users/Administrator/AppData/Local/rclone/vfs/aws_s3/b1sqlsrv-backup"
2021/07/30 17:18:33 DEBUG : fs cache: switching user supplied name "\\?\C:\Users\Administrator\AppData\Local\rclone\vfs\aws_s3\b1sqlsrv-backup" for canonical name "//?/C:/Users/Administrator/AppData/Local/rclone/vfs/aws_s3/b1sqlsrv-backup"
2021/07/30 17:18:33 DEBUG : Network mode mounting is disabled
2021/07/30 17:18:33 DEBUG : Mounting on "c:\aws_s3\sqlbackup" ("aws_s3 b1sqlsrv-backup")
2021/07/30 17:18:33 DEBUG : S3 bucket b1sqlsrv-backup: Mounting with options: ["-o" "attr_timeout=1" "-o" "uid=-1" "-o" "gid=-1" "--FileSystemName=rclone" "-o" "volname=aws_s3 b1sqlsrv-backup"]
2021/07/30 17:18:33 DEBUG : vfs cache RemoveNotInUse (maxAge=3600000000000, emptyOnly=false): item DB_Backup_Daily/ChromeSetup.exe not removed, freed 0 bytes
2021/07/30 17:18:33 INFO : vfs cache: cleaned: objects 1 (was 1) in use 0, to upload 0, uploading 0, total size 1.236Mi (was 1.236Mi)
2021/07/30 17:18:33 DEBUG : S3 bucket b1sqlsrv-backup: Init:
2021/07/30 17:18:33 DEBUG : S3 bucket b1sqlsrv-backup: >Init:
2021/07/30 17:18:33 DEBUG : /: Statfs:
2021/07/30 17:18:33 DEBUG : /: >Statfs: stat={Bsize:4096 Frsize:4096 Blocks:274877906944 Bfree:274877906944 Bavail:274877906944 Files:1000000000 Ffree:1000000000 Favail:0 Fsid:0 Flag:0 Namemax:255}, errc=0
2021/07/30 17:18:33 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:33 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:33 DEBUG : /: Readlink:
2021/07/30 17:18:33 DEBUG : /: >Readlink: linkPath="", errc=-40
The service rclone has been started.
2021/07/30 17:18:33 DEBUG : /: Statfs:
2021/07/30 17:18:33 DEBUG : /: >Statfs: stat={Bsize:4096 Frsize:4096 Blocks:274877906944 Bfree:274877906944 Bavail:274877906944 Files:1000000000 Ffree:1000000000 Favail:0 Fsid:0 Flag:0 Namemax:255}, errc=0
2021/07/30 17:18:33 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:33 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:33 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:33 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:33 DEBUG : /: Opendir:
2021/07/30 17:18:33 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:33 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:33 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:33 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:33 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Opendir:
2021/07/30 17:18:34 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:34 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:34 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:34 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:34 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Opendir:
2021/07/30 17:18:34 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:34 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:34 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:34 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:34 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Opendir:
2021/07/30 17:18:34 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:34 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:34 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:34 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:34 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Opendir:
2021/07/30 17:18:34 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:34 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:34 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:34 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:34 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Opendir:
2021/07/30 17:18:34 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:34 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:34 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:34 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:34 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:34 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:34 DEBUG : /: Opendir:
2021/07/30 17:18:34 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:34 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:34 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:34 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:34 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Opendir:
2021/07/30 17:18:35 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:35 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:35 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:35 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:35 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Opendir:
2021/07/30 17:18:35 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:35 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:35 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:35 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:35 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Opendir:
2021/07/30 17:18:35 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:35 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:35 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:35 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:35 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:35 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:35 DEBUG : /: Opendir:
2021/07/30 17:18:35 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:35 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:35 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:35 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:35 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /filestream.hdr: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /filestream.hdr: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Opendir:
2021/07/30 17:18:44 DEBUG : /: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : /: >OpenFile: fd=/ (r), err=
2021/07/30 17:18:44 DEBUG : /: >Opendir: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /: Releasedir: fh=0x0
2021/07/30 17:18:44 DEBUG : /: >Releasedir: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=-2
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: CreateEx: flags=0x502, mode=0770
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: Open: flags=O_RDWR|O_CREATE|O_EXCL
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: newRWFileHandle:
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc0000e2600): openPending:
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: vfs cache: truncate to size=0
2021/07/30 17:18:44 DEBUG : : Added virtual directory entry vAddFile: "SBODemoCN.bak"
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc0000e2600): >openPending: err=
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: >newRWFileHandle: err=
2021/07/30 17:18:44 DEBUG : : Added virtual directory entry vAddFile: "SBODemoCN.bak"
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: >Open: fd=SBODemoCN.bak (rw), err=
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >CreateEx: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Truncate: size=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Truncate: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Fsync: datasync=false, fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Fsync: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Flush: fh=0x0
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc0000e2600): RWFileHandle.Flush
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Flush: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Release: fh=0x0
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc0000e2600): RWFileHandle.Release
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc0000e2600): close:
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: vfs cache: setting modification time to 2021-07-30 17:18:44.9160259 +0000 GMT m=+11.388831401
2021/07/30 17:18:44 INFO : SBODemoCN.bak: vfs cache: queuing for upload in 5s
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc0000e2600): >close: err=
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Release: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0xFFFFFFFFFFFFFFFF
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: OpenEx: flags=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: OpenFile: flags=O_RDONLY, perm=-rwxrwxrwx
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: Open: flags=O_RDONLY
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: newRWFileHandle:
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: >newRWFileHandle: err=
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: >Open: fd=SBODemoCN.bak (rw), err=
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >OpenFile: fd=SBODemoCN.bak (rw), err=
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >OpenEx: errc=0, fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Getattr: fh=0x0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Getattr: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Unlink:
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: Remove:
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: vfs cache: cancelling writeback (uploading false) 0xc000452a10 item 1
2021/07/30 17:18:44 INFO : SBODemoCN.bak: vfs cache: removed cache file as file deleted
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: vfs cache: removed metadata from cache as file deleted
2021/07/30 17:18:44 DEBUG : : Added virtual directory entry vDel: "SBODemoCN.bak"
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak: >Remove: err=
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Unlink: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Flush: fh=0x0
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc00006cec0): RWFileHandle.Flush
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Flush: errc=0
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: Release: fh=0x0
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc00006cec0): RWFileHandle.Release
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc00006cec0): close:
2021/07/30 17:18:44 DEBUG : SBODemoCN.bak(0xc00006cec0): >close: err=
2021/07/30 17:18:44 DEBUG : /SBODemoCN.bak: >Release: errc=0
2021/07/30 17:19:33 DEBUG : vfs cache RemoveNotInUse (maxAge=3600000000000, emptyOnly=false): item DB_Backup_Daily/ChromeSetup.exe not removed, freed 0 bytes
2021/07/30 17:19:33 INFO : vfs cache: cleaned: objects 1 (was 1) in use 0, to upload 0, uploading 0, total size 1.236Mi (was 1.236Mi)

Thanks for your reply!

4

Hi,

make sure the backup script works to local storage. <-- it works to backup to local directory
if that works, then try to backup to the rclone mount. <-- failed

For your information.

Thanks!

5

well, there are no errors in that rclone log.
looks like the backup script creates SBODemoCN.bak, then deletes the backup file.

those ms sql errors look very detailed.
have you figured out exactly what they mean?

do you have enough free disk space on local fort the vfs cache to store the full backup file?

is the backup a full, differential or what?

6

Yes, I have enough free disk space (55.3 GB free of 79.9 GB) for the vfs cache.
I made a full backup of the database.

7

that looks like a bucket, not a folder.
just a guess, but i would try to backup to a folder

8

yse, b1sqlsrv-backup is a bucket and a folder called "DB_Backup_Daily" under it.
run the command
BACKUP DATABASE SBODemoCN TO DISK = 'C:\aws_s3\sqlbackup\DB_Backup_Daily\SBODemoCN.bak';

it still failed as the same errors.
Msg 3202, Level 16, State 1, Line 1
Write on "C:\aws_s3\sqlbackup\DB_Backup_Daily\SBODemoCN.bak" failed: 87(The parameter is incorrect.)
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

9

those ms sql errors look very detailed.
have you figured out exactly what they mean?

10

I could not find useful information about this error.

I also found the similar topic from this forum as below

but I don't know how the author made it possible to back up the database to the root of the S3 bucket...

11

Hi,

My issue is solved by the following mount statement.
.\rclone.exe mount aws_s3:b1sqlsrv-backup F: --vfs-cache-mode full --volname \clouds3\share

After mounting the bucket, run the command within SQL management studio
BACKUP DATABASE SBODemoCN TO DISK = '\clouds3\share\SBODemoCN.bak';
and the database backup to S3 is done successfully.

12

i wonder what was the actual fix. would be helpful to know for future rcloners with the problem.

  • backing up to a net share itself
    or
  • the implied --network-mode when using a net share.

if you have time, perhaps try
.\rclone.exe mount aws_s3:b1sqlsrv-backup F: --vfs-cache-mode full --network-mode
and
BACKUP DATABASE SBODemoCN TO DISK = 'F:\SBODemoCN.bak';

13

it doesn't work if
.\rclone.exe mount aws_s3:b1sqlsrv-backup F: --vfs-cache-mode full --network-mode
and
BACKUP DATABASE SBODemoCN TO DISK = 'F:\SBODemoCN.bak';

I will get another errors:
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'F:\SBODemoCN.bak'. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.

14

Hi,

I am going to go to bed as right now is 4:21 AM in Taiwan Time Zone.
I will reply your message after getting up.
Thanks for your understanding.

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.