We have mounted S3 bucket as network drive in windows SQL server ( having server 2012 R2 OS).& put back path directory in SQL management studio to store SQL backup direct to S3. But when we trigger the backup , it is first copy backup to C:\ drive then the mounted S3 drive.
Can anyone help me so that I can direct store backup to S3 bucket which is mounted as a drive in our case. ( X drive is the mounted drive )
when you posted, you should have been asked for information.
and for the sql backup, what are the settings, how do you run the backup, via command line, sql management studio?
the more info you share, the better we can help you.
I am using SQL management studio , I have mounted the drive as X drive. below is the setting of my SQL . When I trigger for backup ,it will first goes to below directory & then to my destination which is X drive ( S3 bucket).
C:\Windows\system32\config\systemprofile\AppData\Local\rclone\vfs\S3Mount