Why does rds_tlog_backup_copy_to_S3 result in an internal error in processing the task

Question

I've got a RDS MSSQL 2014 running. I can create backups on an S3. I was trying to start log-shipping for replication.

Followed the documentation https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER.SQLServer.AddlFeat.TransactionLogAccess.html

I've setup the bucket, with the policy and owner rights. 
I've executed the setup sp as well. Worked fine. `msdb.dbo.rds_tlog_copy_setup`

However, when I execute `rds_tlog_backup_copy_to_S3`. the task that gets created results in an error with the following message:

`[2023-04-06 06:47:22.123] Task execution has started. > `

`[2023-04-06 06:47:22.303] Task has been aborted `

`[2023-04-06 06:47:22.307] There was an internal error in processing the task. Try again at a later time.`

I've ensured that my KMS keys used in `rds_tlog_copy_setup` is the same as the one used for RDS

iaun · Answer

From the documentation:
If the DB instance is encrypted, regardless of encryption type (AWS managed key or customer managed key), you must provide a customer managed KMS key in the IAM role and in the rds_tlog_backup_copy_to_S3 stored procedure.

I solved the problem using a customer managed KMS key.

Gary Nguyen · Answer

Hi,

May i ask if u have solved this issue already ?

Thanks

Why does rds_tlog_backup_copy_to_S3 result in an internal error in processing the task

Add your answer

Relevant content