SFTP

Adding SFTP storage as a backup destination

To send backups to SFTP storage, you first need to set up a destination in the “Storages” page:

1. Go to the “Storages” page and click “Add Storage” and select SFTP as the storage destination:

Add SFTP storage destination

2. In the “New SFTP Settings” pop-up window, enter the following credentials:

  • Host – Network name of your SFTP host. This is usually a domain name or an IP address, such as MyFtpServer.com or 127.23.121.33.
  • Port – Port number your SFTP server uses (usually 22 )
  • User Name – Username for authentication.
  • Authentication method – Authentication method used by your SFTP server:
    • Password

    • Public / Private key

Once configured, click “Test” to verify the connection. If successful, click “Save & Close” to apply your settings.

These are the basic settings required to configure SFTP as a backup destination.

SFTP destination settings

Advanced SFTP settings (Optional)

You can further customize your SFTP backup storage with the following advanced options:

  • Verify server fingerprint – Enables verification of the server’s public key fingerprint for added security. Example:
    1f:cb:d3:47:8d:ca:05:0c:87:15:98:91:03:9b:ec:b4

  • Limit transfer speed – Set a maximum speed for data transfers to avoid consuming all available bandwidth.

  • Keep alive – Sends periodic commands to keep the SFTP connection active during long transfers. Configure this by setting the Connection keep alive interval in seconds.

  • Validate file checksum after transfer – Verifies data integrity by checking the file checksum after the transfer is completed.

  • Use large buffers – Use larger receive buffer for incoming and outgoing data.

  • Timeout, ms – Set the timeout duration in milliseconds for SFTP operations.

SFTP destination advanced settings SFTP destination more advanced settings

Steps to add SFTP storage to a backup job:

  1. Return to the Dashboard page.

  2. Open the backup job you want to modify (or create a new one), and click the “Edit” button.

  3. Navigate to the Storage Destination section.

  4. Click “Add Backup Storage”.

 

Add storage destination SqlBak

5. Select SFTP storage as the destination.

Select SFTP destination

6. In the configuration window, specify the following:

    • Autodelete old backups after – Define a retention period for automatically deleting old backups.

    • Enable minimum backups – Set the minimum number of backups to retain, even if they exceed the defined retention period.

      SFTP storage retention settings SqlBak

Optional settings:

  • Store the following backup types (Full, Diff, T-Log) – Choose which backup types to store in this destination.

  • Auto delete Differential backups after – Define a retention period specifically for differential backups.

  • Auto delete T-Log backups after – Define a retention period specifically for transaction log backups.

  • Enable minimum Differential or T-Log backups – Set the minimum number of differential or T-Log backups to keep, even if older than the retention limit.

  • Emergency storage – Use this option to designate SFTP as an emergency/failover destination in case the primary backup storage becomes unavailable.

SFTP storage options