Breaking News: Grepper is joining Read the official announcement!
Check it out

Backup and Recovery options

Pragya Keshap answered on February 21, 2023 Popularity 1/10 Helpfulness 1/10


More Related Answers

  • SQL Restore Database From Backup
  • sql restore backup query
  • Restore from backup SQL File
  • restore backupfile discourse
  • Restore backup

  • Backup and Recovery options


    Automated backups are performed daily and have a retention period ( of max 35 days) and can be used to restore and create a new database.

    Manual (on-demand) backups are called Snapshots and have no retention period ( they do not expire and must be deleted manually). They backup entire DB instance, not just individual DBs and can cause suspension of I/O in case of single AZ (from few seconds to few minutes).

    In case of multi-AZ there is not hiccup (with the exception of SQLServer) because backup is taken from the StandyBy instance.

    Snapshots can be exported out of RDS to S3 and allow further analysis with other tools like Athena, SageMaker or EMR.

    You can choose to simply export specific databases, tables or schemas.

    Popularity 1/10 Helpfulness 1/10 Language whatever
    Source: Grepper
    Link to this answer
    Share Copy Link
    Contributed on Feb 21 2023
    Pragya Keshap
    0 Answers  Avg Quality 2/10


    Continue with Google

    By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.
    Grepper Account Login Required

    Oops, You will need to install Grepper and log-in to perform this action.