Required MS SQL permissions to perform backups

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.


Thank you for the details.

That issues related to the verification process. Please find more details at: RESTORE VERIFYONLY (Transact-SQL) - SQL Server | Microsoft Docs

This operation requires permissions to create a database.

You can disable the verification process at your backup job settings at the “Backup options” section by disabling “Verify After Backup”.

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