I’m trying out the product for the first time so I created a backup job and a SQL user belonging to the Global Public role and is a member of db_backupoperator for each DB including system and non-system DBs.
Each time I run the backup I get the error: "Failed to backup “db name” database with “Full” backup type: One or more errors occurred. > CREATE DATABASE permission denied in database ‘master’.
According to docs on MS the public global role and db_backupoperator should be enough for backups.
What does SqlBackupAndFTP require?
I’ve tested it with the ‘sa’ SQL user and it works, but I’d like to avoid that if possible.