Competition: What’s your favorite Redgate tool? Enter now.

Backup Permissions

I am having an issue where I get a permission error when backing up from the schedule job full/differential jobs. When I request the backup job manually I get success.

I tried entering the regedit for skipchecks =1 but it does not seem to work.

Any thoughts?


zblyade275ze.png


SQL Backup log file 9.1.4.177

-SQL "BACKUP DATABASES [model,msdb,appmonamericas,MC_Internal_3_3,pocdb03,ReportServer$AMPSQLINTL,ReportServer$AMPSQLINTLTempDB] TO DISK = 'I:\Backup\<database>\<AUTO>.sqb' WITH ERASEFILES_ATSTART = 15, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT =
10, COMPRESSION = 2, THREADCOUNT = 3, DIFFERENTIAL "

ERRORS AND WARNINGS


10/27/2017 1:38:45 PM: Backing up model (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:45 PM: I:\Backup\model\DIFF_AMPSQLINTL_model_20171027_133845.sqb

10/27/2017 1:38:45 PM: Error 880: BACKUP DATABASE permission denied in database: (model)
10/27/2017 1:38:45 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.

10/27/2017 1:38:45 PM: Backing up msdb (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:45 PM: I:\Backup\msdb\DIFF_AMPSQLINTL_msdb_20171027_133845.sqb

10/27/2017 1:38:46 PM: Error 880: BACKUP DATABASE permission denied in database: (msdb)
10/27/2017 1:38:46 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.

10/27/2017 1:38:46 PM: Backing up appmonamericas (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:46 PM: I:\Backup\appmonamericas\DIFF_AMPSQLINTL_appmonamericas_20171027_133846.sqb

10/27/2017 1:38:46 PM: Error 880: BACKUP DATABASE permission denied in database: (appmonamericas)
10/27/2017 1:38:46 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.

10/27/2017 1:38:46 PM: Backing up MC_Internal_3_3 (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:46 PM: I:\Backup\MC_Internal_3_3\DIFF_AMPSQLINTL_MC_Internal_3_3_20171027_133846.sqb

10/27/2017 1:38:47 PM: Error 880: BACKUP DATABASE permission denied in database: (MC_Internal_3_3)
10/27/2017 1:38:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.

10/27/2017 1:38:47 PM: Backing up pocdb03 (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:47 PM: I:\Backup\pocdb03\DIFF_AMPSQLINTL_pocdb03_20171027_133847.sqb

10/27/2017 1:38:47 PM: Error 880: BACKUP DATABASE permission denied in database: (pocdb03)
10/27/2017 1:38:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.

10/27/2017 1:38:47 PM: Backing up ReportServer$AMPSQLINTL (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:47 PM: I:\Backup\ReportServer$AMPSQLINTL\DIFF_AMPSQLINTL_ReportServer$AMPSQLINTL_20171027_133847.sqb

10/27/2017 1:38:48 PM: Error 880: BACKUP DATABASE permission denied in database: (ReportServer$AMPSQLINTL)
10/27/2017 1:38:48 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.

10/27/2017 1:38:48 PM: Backing up ReportServer$AMPSQLINTLTempDB (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:48 PM: I:\Backup\ReportServer$AMPSQLINTLTempDB\DIFF_AMPSQLINTL_ReportServer$AMPSQLINTLTempDB_20171027_133848.sqb

10/27/2017 1:38:49 PM: Error 880: BACKUP DATABASE permission denied in database: (ReportServer$AMPSQLINTLTempDB)
10/27/2017 1:38:49 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
Tagged:

Answers

Sign In or Register to comment.