To create a Amazon S3 backup destination, click the Add toolbar button in the Destinations section of the Database Backup Editor window. When prompted to choose a destination, select Amazon S3 and click the Select button.
In order to upload database backup files on your behalf, SQL Backup Master requires the following information:
•Access and secret keys - These can be found on the "Security Credentials" page of your Amazon Web Services account.
•Bucket name - If you haven't already, log into your Amazon AWS account, navigate to the S3 configuration area, and create a bucket for use by your organization.
Important: SQL Backup Master will not use your Amazon AWS authentication information for any purpose other than those directly required by the application (e.g. uploading, download, listing, and clean up of database backup files). This information is stored (associated with the backup job) in encrypted form, and is never transmitted to any other external party.
The following optional settings are also available:
•Remote dir - By default, SQL Backup Master will upload database backup files into the root of your Amazon S3 bucket. Here, you can specify a directory name (e.g. "SQL Backups" or something similar) to use instead. If the directory doesn't already exist, it will be created. You can also specify multiple sub-directories by separating them with a forward slash (e.g. "Apps/SQL Backups").
•Storage class - Specifies the Amazon S3 storage class that should be used for database backup files. The "standard" and "reduced redundancy" storage class options have different redundancy guarantees and associated costs (please see Amazon S3 FAQ for details).
•Concurrency - Allows you to control the number of simultaneous upload request threads. A higher concurrency value may result in faster upload times, depending upon various factors (such as available bandwidth, proximity to S3 endpoint, etc.). Use a lower concurrency value when you wish to constrain bandwidth usage.
•Encryption - Use this option to apply Amazon S3 server-side AES-256 encryption to the backup file on the server.
•Acceleration - Use this option to engage Amazon S3 transfer acceleration feature. Important: Transfer acceleration must be enabled on the target S3 bucket before you can use this feature.
•GovCloud account - Check this box if you're uploading database backups to an Amazon GovCloud account.
•Emergency destination - When this option is enabled, the associated backup destination will be used only if all other backup destinations fail.
Each time SQL Backup Master successfully uploads a database backup to a destination, it executes a clean-up procedure.
This allows you to automatically remove database backup files that are older than a specified number of days.
Important: Cleanup operations for a given destination will only affect the database backup files associated with that destination.