We have some AWS RDS SQL Server instances that we are setting up. Some of these will be Multi-AZ for HADR.
We know that RDS will take system level backups and snapshots. We are wanting to perform individual backups into S3 buckets so we can use the backups for stage and dev restores on central dev server.
We are using SQL Server Agent jobs to perform these backups but the jobs on SQL Server Agent read successful even if the backup to the S3 bucket fails.
What I am curious about is if anyone has figured out a solution to monitor these backups to the S3 buckets since SQL Server Agent jobs are not showing the failure correctly. Only possible solution I can think of is Powershell but would love to hear anyone else's solution if they have one.