SQL Server Agent Backup Options
Published 22 November 2018
These options are stored in the registry on the machine that is running the SQL Instance
Open Registry Editor and locate HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(local) or <instance name>
| Name | Type | Values | Description | Restart SQL Backup Agent |
|---|---|---|---|---|
| ConnectionEncrypt | DWORD | 0/1 | Connect by encrypting the connection to SQL Server | No |
| ConnectionTrustServerCertificate | DWORD | 0/1 | Connect by trusting the Server Certificate | No |
| AllowSQLBrowsing | DWORD | 0/1 | To enable folder and file browsing by SQL Authenticated users | No |
| BrowsingUserList | REG_SZ or REG_MULTISZ | usernames | List of allowed users (in the form domain\username) | No |
| BrowsingDomain | REG_SZ | AD Name | The Active Directory name that is used to browse for the AD Groups (This is not required but could help in resolution of AD) | No |
| BrowsingADGroups | REG_SZ or REG_MULTISZ | AD Groups | A list of Active Directory Groups that contain users (Can be used instead of BrowsingUserList | No |
| AlwaysBufferFile | DWORD | 0/1 | Force Buffered-Reads & Writes for Backup and Restoring | No |
| COPYTO:CopyIntervalInMinutes | DWORD | The initial interval between upload attempts (2 minutes by default). | ||
| COPYTO:MaxCopyIntervalCount | DWORD | The number of upload attempts for which the interval to the next upload attempt is increased (5 by default). | ||
| COPYTO:ExpiryIntervalInMinutes | DWORD | The maximum time to continue with upload attempts (1440 minutes by default). | ||
| COPYTO:ThreadCount | DWORD | The number of files that can be uploaded simultaneously (5 by default). Maximum value is 10. | ||
| LOGFILESEARCH | DWORD | 0/1 | Set to 1 to enable logging of files searching. | No |
| SetEOF | DWORD | 0/1 | Improve speed by pre-allocating the backup file on a NetApp SMB device | No |
Open Registry Editor and locate HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(local)
(These settings are used by all instances to communicate with the AWS/S3)
| Name | Type | Values | Description | Restart SQL Backup Agent |
|---|---|---|---|---|
| HostedStorageS3ProxyUserName | REG_SZ | 0/1 | username to be used by proxy | No |
| HostedStorageS3ProxyPassword | REG_SZ | 0/1 | password to be used by proxy | No |
| HostedStorageS3ProxyDomain | REG_SZ | 0/1 | Domain to be used by proxy | No |
