Perform a backup of Managed SQL Server (AWS) to S3

- Reading time: ~1 minute

Connect to Microsoft SQL Server Management Studio and execute the below stored procedure, providing the database name and destination bucket:

exec msdb.dbo.rds_backup_database

@source_db_name='database_name',

@s3_arn_to_backup_to='arn:aws:s3:::bucket_name/file_name_and_extension',

@overwrite_S3_backup_file=1;

2. Check the progress of the backup with the following:

exec msdb.dbo.rds_task_status

3. Confirm the updated fiels are present in S3 Bucket