What are the challenges you face when working across database platforms? Take the survey
Options

Error 880: BACKUP DATABASE permission denied

HI Guys,
When I try to do a scheduled backup (Full/Diff/Tran Log) I get the following error:

Error 880: BACKUP DATABASE permission denied in database: (DB NAME)
SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'Domain\User' does not exist, its corresponding server principal does not have server access, this type of database principal cannot
be impersonated, or you do not have permission.

I can do a manual back up and it works fine.

Many Thanks

Answers

Sign In or Register to comment.