SQL Backup Master supports the use of an FTP Server for database backup purposes.
To create a Google Drive backup destination, click the Add toolbar button in the Destinations section of the Database Backup Editor window. When prompted to choose a destination, select FTP Server and click the Select button.
The following settings are required in order to locate and authenticate to your FTP server:
•Host address - The host name or IP address of the computer providing FTP services.
•Username - The username of your FTP server account.
•Password - The password of your FTP server account.
The following optional settings are also available:
•Remote dir - By default, SQL Backup Master will upload database backup files into your FTP user account root. 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").
•Protocol - Choose from one of the following:
oStandard connection - Standard FTP connection.
oSecure TLS/SSL Explicit - FTPS in explicit mode (starts as an unencrypted FTP session and is secured on client request).
oSecure TLS/SSL Implicit - FTPS in implicit mode (is secured right from the beginning and therefore needs a separate TCP port 990).
oSecure SFTP via SSH - Runs over an SSH session on port 22.
•Port - This can be specified only when using a standard (non-encrypted) FTP protocol.
•Upload limit - Provides a means of throttling the upload speed. Use this option if you wish to conserve outgoing bandwidth.
•Proxy configuration - Use the optional proxy configuration fields to indicate the host, port, and authentication credentials to be used to proxy FTP connections. Note that numerous proxy type option changes depending upon whether you're using standard or secure FTP protocols.
•Use passive connection - Uncheck this option if you need to use an active FTP connection (e.g. due to firewall configuration, etc.).
•Write FTP commands to backup log (verbose) - Records all FTP command interactions to the backup log. Should be used only for brief diagnostic periods.
•Accept all TLS/SSL certificates - Use this switch to bypass validation of your FTP server's security certificate.
•Use large buffers - This option uses larger buffer sizes during file transfers, which can improve performance in some scenarios. Consider disabling this option for very slow network connections where large block transfers may take an excessive amount of time.
•Emergency destination - When this option is enabled, the associated backup destination will be used only if all other backup destinations fail.
•Attempt to resume broken uploads - Using this option will cause the automatic upload retry mechanism to attempt to resume broken uploads. This is done by reconnecting to the FTP server and checking to see if a partial file already exists; if so, it will be appended for improved performance.
IMPORTANT: Secure FTP features require a minimum license type of "Professional".
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.