With AWS RDS being a managed service it manages backs and other aspects itself (i.e. no permissions to back up log / truncate manually) - how and when AWS RDS is truncating the transaction log?
I have a MSSQL database with couple read replicas in AWS RDS and the transaction log is growing in size that is causing dramas sometimes.
I can't change the recovery model, cant do backup log, etc. AWS backup SP (msdb.dbo.rds_backup_database) is taking a copy and does not truncates the log.
Just trying to understand how is it supposed to work.
log_reuse_wait_desc shows for the database REPLICATION status. I am guessing the REPLICATION status means data being sent to read replicas, but not sure why this is happening constantly and the log_reuse_wait_desc does not change