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

0

Hello,

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
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.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html#SQLServer.Procedural.Importing.Native.Using.Backup

profile picture
EXPERT
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