how to Copy .bak file from S3 to RDS - Amazon Cloud

  • lsalih

    SSCertifiable

    Points: 6141

    Greetings -

    I am trying to setup a DR solution.. I was able to copy .bak file to S3 bucket in AWS using Powershell. I now need to copy the .bak file in the S3 bucket to the RDS instance I created, running in Windows, to restore the database.

    The question I have is how to copy the .bak file to the RDS instance to restore? Can you please guide me here.

  • lsalih

    SSCertifiable

    Points: 6141

    After doing much reading, I learned that I am unable to load the backup file to RDS instance since backup and restore are not supported. A paid instance is needed to do my work. If anyone has any advise, please let me know. Thank you.

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715375

  • Jeff Moden

    SSC Guru

    Points: 994542

    I read that article and I can't help but think that the cloud is becoming more like smoke and mirrors. Now you see it, now you don't.;-)

    --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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

  • lsalih

    SSCertifiable

    Points: 6141

    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.

  • Jeff Moden

    SSC Guru

    Points: 994542

    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.
    "If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
    "Change is inevitable... change for the better is not."
    When you put the right degree of spin on it, the number 3|8 is also a glyph that describes the nature of a DBAs job. 😉

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

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply