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.

  • 3
    Post your job config? – Tony Hinkle Feb 28 '19 at 20:35
  • Here is link to AWS article. aws.amazon.com/premiumsupport/knowledge-center/… – Corey Hambrick Feb 28 '19 at 20:41
  • You have to use a native RDS proc. Removed @ with - DECLARE -BackupFileName varchar(200) SET -BackupFileName = 'arn:aws:s3:::s3_bucketname_goes_here/' + -DBname + '/' + -DBname +'_' + -DateText + '.BAK' <br /> EXEC msdb.dbo.rds_backup_database source_db_name = -DBname, s3_arn_to_backup_to = -BackupFileName, -overwrite_S3_backup_file = 1, -type = -BackupType – Corey Hambrick Feb 28 '19 at 20:47
  • @corey - add that as an answer – Max Vernon Mar 1 '19 at 4:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.