Backup SQL Server Database on RDS with SQL Server Agent on S3 Bucket



I have one database in RDS on SQL Server, i have also enabled SQL Sever Agent. I want to perform daily backup ( so i want to add cron job) on the database to S3 via the SQL Server Agent.

How is the procedure?

Thank you a lot!

1 Answer

First of all you will need to setup the option group and specify an IAM role which has the correct access to the S3 bucket and keys.

Then your agent will need to execute the SQL command eg:-

exec msdb.dbo.rds_backup_database

You can get away with only specifying the mandatory options only.

profile picture
answered 7 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions