Creating a Windows SQL Server database fails when the destination file is in a subdirectory. Works OK when you save the file to the root folder on the S3 Bucket.
Windows Server 2016
AWS S3 Bucket
mount s3-awsbkpcog01:s3-awsbkpcog01/ S: --vfs-cache-mode full --config "C:\Program Files\rclone\.config\rclone\rclone.conf"
[s3-awsbkpcog01] type = s3 provider = AWS env_auth = false access_key_id = secret_access_key = region = eu-central-1 location_constraint = EU storage_class = STANDARD
The latest version of Microsoft SQL, which is MSSQL 2019 CU19 (15.0.4102.2) is able to create a sql file or a database backup inside a directory.
MSSQL 2019 RTM (15.0.2000.5) or versions prior to to this, i.e. MSSQL 2017, 2016 etc. are unable to create a sql file inside a folder on winfsp. With every version of MSSQL a backup or database file can be created on the root of the filesystem.
2021-03-30 10:29:57.66 Backup BackupIoRequest::ReportIoError: write failure on backup device 'S:\test\test.bak'. Operating system error 87(The parameter is incorrect.). 2021-03-30 10:29:57.66 Backup Error: 3041, Severity: 16, State: 1. 2021-03-30 10:29:57.66 Backup BACKUP failed to complete the command BACKUP DATABASE
I opened a support case at Microsoft already, but Microsoft will not investigate the case, if additional software like rclone is used. I also created a Bug report in Github, because I thougt this would be a problem with winfsp, but they think it's more a Rclone issue.
Any support will be greatly appreciated.