Copy back from S3?

TedMaulUK2

Hi folks,

Backing up to an S3 bucket with SQL Backup is working very well however are there any plans to allow a restore from a bucket?  Seems a bit of gap in functionality when it's able to copy files from a server to an S3 bucket but unable to do it the other way before a restore.... Unless of course I'm missing a trick

Logging in to S3 and manually downloading the files on the server isn't really an option for me....

Dan_J

Hi @TedMaulUK2

Thanks for reaching out to us regarding this!

I'm glad that backing up to an S3 bucket is working well for you! I completely agree with you that not having restore functionality is a bit of a gap, however I'm afraid that there are currently no plans to add it.

I have made our development team aware of this suggestion, however I'm not able to advise on whether or not they will look to at this functionality in the future.

TedMaulUK2

Thanks for that Dan, and glad (in some ways!) I wasn't missing an obvious option in SQL Backup.

There's a couple of work arounds for Windows but I'm testing TNTDrive which allows an S3 bucket to be mapped a Windows drive which SQLBackup is able to restore directly from which is looking like a good solution.

Dan_J

Hi @TedMaulUK2

No problem at all!

Just to mention also, should it be useful to you, someone here made the suggestion of using this: https://aws.amazon.com/storagegateway/file/ as a way of restoring from AWS. 

SQL4Me

I want to upvote this! We need this too. Is there a feature request page that we can vote on for this feature?