SQL Backup failed with exit code: 669

• 
  SQL Backup generates a log file for each process that it runs. The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.
  
  Could you please post the contents of the log file for the backup that failed?

  petey November 11, 2013 18:52

  - 0 +
• 
  SQL Backup Exit Code 669 indicates that the start-up account for the SQL Backup Agent service does not have read / write permissions to the SQL Backup registry folders.
  
  Please check the following registry folders and ensure that the account given to the SQL Backup Agent service has read/write permissions to the following registry folders:
  
  HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettings\<InstanceName>
  HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<InstanceName>
  HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\InstalledInstances\<InstanceName>
  
  Where <InstanceName> is the name of the SQL Instance for a named instance or (local) for the default instance?
  
  Many Thanks
  Eddie

  Eddie D November 28, 2013 05:14

  - 0 +
• 
  There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
  I am trying to change the SQL Backup Agent Service account. It is a member of SysAdmin fixed server role on the instance. SQL 2008R2 Standard on Windows 2008R2 Data Center.

  rayherring August 12, 2017 21:50

  - 0 +
• 

  rayherring wrote: »

  There must be something else that causes this error because I have assigned the new Service Account Full Control of the entire key from ..\BackupSettings down and I still see the error.
  I am trying to change the SQL Backup Agent Service account. It is a member of SysAdmin fixed server role on the instance. SQL 2008R2 Standard on Windows 2008R2 Data Center.

  
  It turns out account needs access to HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal as well.

  rayherring August 12, 2017 21:57

  - 0 +

Add comment

Please sign in to leave a comment.