SQL Backup error 605 SQL Backup error 605

SQL Backup error 605

If the SQL Backup Error 605 is thrown when attempting to backup a database, you should check that the startup user account for the SQL Backup Agent Windows service meets the minimum permission requirements below.

You can check which user account is logged in by right clicking on the SQL Backup Agent Windows service, then select Properties > Log on.

mceclip0.png

Permissions required by the SQL Backup Agent service

The SQL Backup Agent service is a Windows service which SQL Backup Pro uses to perform backup and restore operations through the GUI. You specify the user account used to log on to the SQL Backup Agent service (the startup account) when you install the server components on a SQL Server instance. 

The user account used to log on to the SQL Backup Agent service (the startup account) and connect to the SQL Server requires:

  • "Log on as a service" rights in order to start the service.
  • If using Windows authentication to connect to the SQL Server, membership of the SQL Server sysadmin fixed server role. If using SQL Server authentication, the SQL Server authenticated account must be a member of the SQL Server sysadmin fixed server role, but the startup account does not need to be. For information on changing the authentication mode the SQL Backup Agent service startup account uses to connect to the SQL Server instance, see Changing the authentication mode below.
  • Access to any network locations that will be backed up or copied to, or restored from.
  • Access to the following folders:
    • The SQL Backup Pro local data store. By default, this is installed in %PROGRAMDATA%\Red Gate\SQL Backup\Data (for Windows Server 2008, Windows Server 2008 R2, Windows Vista and Windows 7) or %ALLUSERSPROFILE%\Application Data\Red Gate\SQL Backup\Data (for Windows Server 2003 and Windows XP).
    • The SQL Backup Pro logs folder. By default this is %PROGRAMDATA%\Red Gate\SQL Backup\Log (for Windows Server 2008, Windows Server 2008 R2, Windows Vista and Windows 7) or %ALLUSERSPROFILE%\Application Data\Red Gate\SQL Backup\Log (for Windows Server 2003 and Windows XP).
    • The SQL Backup Pro backup settings registry folder HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettings\<instance>
    • The SQL Backup Pro backup settings global registry folder HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance>
    • The Red Gate licensing registry folder HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\Licensing\SQL Backup or HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Red Gate\Licensing\SQL Backup (for 64-bit machines).
    • The Red Gate licenses folder %PROGRAMDATA%\Red Gate\Licenses (for Windows Server 2008, Windows Server 2008 R2, Windows Vista and Windows 7) or %ALLUSERSPROFILE%\Application Data\Red Gate\Licenses (for Windows Server 2003 and Windows XP).
    • The Microsoft MSSQLServer setup registry folder HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup (read access only).