Which results in the following:
Msg 262, Level 14, State 1, Line 1
BACKUP DATABASE permission denied in database ‘HamShackRadio’.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Completion time: 2020-06-26T08:34:23.5511314-04:00
In short, by default, you can’t backup SQL Server databases on RDS. However, that’s by default. We can make some changes.
Read on to see the proper way of backing up a database hosted in RDS.