Options

Service Account security

noob2016noob2016 Posts: 22 Bronze 3
in SQL Backup
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
Tagged:
· Share on Twitter

Best Answer

Answers

  • Options
    noob2016noob2016 Posts: 22 Bronze 3
    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
    · Share on Twitter
Sign In or Register to comment.