Home Forums Cloud Computing General Cloud Computing Questions how to Copy .bak file from S3 to RDS - Amazon Cloud RE: how to Copy .bak file from S3 to RDS - Amazon Cloud

  • July 11, 2016 at 8:41 pm

    #1889531

    lsalih (7/5/2016)

    Steve and Jeff -

    Thank you both for your input. The way I did the work is by creating an Amazon S3 storage in AWS and created an Amazon EC2 (same way the link recommended), but I used Powershell to first write the .bak file to S3 bucket then upload it to the EC2 instance. I used Write-S3Object and Copy-S3Object commands to do the work. I did similar testing to copy .bak file to Azure, I first created a blob and used AzCopy PS command to upload/download the file. Both file uploads were successful.

    I recommend using this method for DR, since the cost you pay is only for reserving a storage area.

    Awesome. Thanks for taking the time to post your solution!

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)