AWS SQL backup - permission denied

How it works
1

Hi,

I am testing sqlbackupandftp with AWS RDS MS SQL. I created a user with the dbbackupoperator rights.

However, I get the below error:

22/3/2022 12:57:39 PM [Error] Failed to backup “RW82” database with “Full” backup type: One or more errors occurred. > BACKUP DATABASE permission denied in database ‘RW82’.
BACKUP DATABASE is terminating abnormally.

What are the minimum permission requirements to get this to work?

Thanks
Marios

2

Hi Marios,

Please find more details about how to set Amazon S3 access policy to minimum permission at Set Amazon S3 access policy to minimum permission | SQLBackupAndFTP's blog

If you have any other questions, please let us know.

Thank you!