1 Answer
- Newest
- Most votes
- Most comments
0
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.
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.BackupRestore.html
Then your agent will need to execute the SQL command eg:-
exec msdb.dbo.rds_backup_database
@source_db_name='database_name',
@s3_arn_to_backup_to='arn:aws:s3:::bucket_name/file_name.extension',
[@kms_master_key_arn='arn:aws:kms:region:account-id:key/key-id'],
[@overwrite_s3_backup_file=0|1],
[@type='DIFFERENTIAL|FULL'],
[@number_of_files=n];
You can get away with only specifying the mandatory options only.
Relevant content
- asked a year ago
- asked 6 months ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 13 days ago
- AWS OFFICIALUpdated 5 months ago
- AWS OFFICIALUpdated 2 years ago