Service Account security

noob2016

Our company's security team requires that the Service Account used to start SQL Server and SQL Server Agent services not a SYSADMIN on the server.

With SQL Backup, I get an error when the backup job runs with error code 880. I found https://documentation.red-gate.com/sbu7/errors-and-warnings/sql-backup-errors-500-5292

which states that the service account has to be sysadmin.

Anyone have a workaround / solution besides changing registry?

Thank you

petey2

Try assigning the 'db_owner' or 'db_backupoperator' role to the SQL Server Agent service startup account for that database and see if the backup works.

noob2016

Great suggestion. Initial test shows DB_BACKUPOPERATOR fixed the issue.

I would have thought it needed similar role to MSDB considering it's a job, but surprisingly, not.

Will update further if it fails when the job runs by itself.

Thank you Petey2