MSSQL RDS Backup to S3

9eb1549cb7181dcdb0a6f97b3740c513.png

  • Assign the group to RDS instance

f14f1d1626b653cc1a5a8d085d9b198d.png

Troubleshooting

  • The transaction log for database is full due to ‘ACTIVE_BACKUP_OR_RESTORE’.

Switch recovery mode to simple before triggering the backup

alter database TestimonialTree set recovery simple

After successful backup, switch back recovery to full

alter database TestimonialTree set recovery full

Ref: Perform Native Backups of SQL Server DB Instances