Ensuring that databases are securely backed up is a fundamental aspect of data management.

The integration of SQLBackupAndFTP and SFTP To Go presents a streamlined and hardy solution for this, facilitating secure and automated database backups that take just a few moments to set up.

This post will show you how.

Why Choose SQLBackupAndFTP AND SFTP To Go?

SQLBackupAndFTP and SFTP To Go together offer a secure, scalable, and user-friendly solution for database backups.

SQLBackupAndFTP is designed to support a range of database management systems, including SQL Server, MySQL, PostgreSQL, Azure SQL, and Amazon RDS SQL.

This compatibility is a key factor for diverse IT environments. The platform facilitates automated and scheduled backups, which are essential for maintaining up-to-date data protection without manual intervention.

Additionally, SQLBackupAndFTP incorporates encryption for data during transfer and storage, while its interface is simple and intuitive, catering to the practical needs of database administrators and IT professionals.

SFTP To Go offers a cloud-based storage solution, critical for businesses looking to avoid the complexities of on-premises infrastructure. The platform's security measures, such as encrypted communications and data encryption at rest, are complemented by the option to use static IPs and inbound network rules.

SFTP To Go is also designed for ease of use, with efficient user and file management systems, supported by a reliable customer service team.

The combination of SQLBackupAndFTP and SFTP To Go is a practical solution for database backups, blending automated backup processes and broad database compatibility with highly secure, cloud-based storage.

This integration caters to the essential needs of high-pace contemporary IT environments, providing a reliable and adaptable strategy for data protection and management.

1. In SFTP To Go

Sign up (if you haven’t already):

Retrieve connection details:

  • After signing up, navigate to the dashboard and go to the “Credentials” tab.
  • Here, you’ll find the necessary connection details such as SFTP To Go cloud server address, username, and password, which we’ll use later in this process.
  • To ensure that SQLBackupAndFTP has a designated space in your storage, you’ll need to create a new user account with read/write permissions, instead of using the root account. You can follow the process for this, step-by-step, in our docs.

Connection details via the SFTP To Go dashboard Credentials Tab
Engaging the warp drive for data. Set course to the backup nebula.

2. In SQLBackupAndFTP

Download and install (if you haven’t already):

  • Visit SQLBackupAndFTP and download the application.
  • Follow the installation instructions to install it on a server in your network that has access to the data you intend to back up.

Connect to database server:

  • Open SQLBackupAndFTP.
  • Under the “Jobs” tab, click on the “Configure” icon in the “Connect to Database Server” panel, as indicated in the screenshot below.
Connecting to database server via the SQLBackupAndFTP Job tab
Initiating the transporter sequence – beaming our data to cloud sector.

  • Choose your server type from the list.
Choosing a server via the SQLBackupAndFTP Job tab
Hailing frequencies open. Awaiting command inputs from Starfleet Command.

  • Enter the server name (where applicable).
  • Select the authentication type.
  • Enter your username and password.
  • Click “Test Connection” to ensure it works.
  • Finally, click “Save & Close” to apply your selection.
Testing server connection and saving via the SQLBackupandFTP Job tab
Diverting auxiliary power to the backup shields. Red alert!

Select databases:

  • Also under the “Jobs” tab in the SQLBackupAndFTP dashboard, navigate to the "Select Databases" section.
  • Then, click on the "Settings" icon, as indicated in the screenshot below.
Accessing database settings via the SQLBackupAndFTP Job tab
Accessing the LCARS database for the latest backup protocols.

  • Check the appropriate boxes to define backup parameters and your database/s of choice.
  • Now, click “Save & Close”.
Selecting your database via the SQLBackupAndFTP Job tab
Running a level-3 diagnostic on our data integrity fields.

Saving and closing to apply your database selection via the SQLBackupAndFTP Job tab
Adjusting the deflector dish to navigate through the asteroid field of server errors.

Add SFTP Storage Destination:

  • In the "Store backups in selected destinations" panel, click on the "Add" icon, as indicated in the screenshot below.
Selecting your backup destination via the SQLBackupAndFTP Job tab
Plotting a course through the subspace network. Engage!

  • A drop down list will appear. Select “FTP Server”.
Selecting your backup storage location via the SQLBackupAndFTP Job tab
Activating the cloaking device for secure, encrypted data transfer.

  • In the popup window, fill all required fields and make all appropriate selections: Host Address (that’s the SFTP To Go cloud server address), Protocol (SFTP), Port (22), User Name, Authentication Method, Path, Deletion Parameters, and Advanced Settings as you see fit.
Entering FTP server details to select backup location via the SQLBackupAndFTP Job tab
Scanning for anomalies in the backup continuum.

Saving and closing to apply your FTP server details via the SQLBackupAndFTP Job tab
Rerouting command codes through the isolinear chips.

  • Now, click “Save & Close”.
  • A popup will appear indicating connection status. If successful, click “OK”.

A popup indicates success via the SQLBackupAndFTP Job tab destination server settings
Setting phasers to 'backup' mode. Ready to fire on my mark!

  • Take note that, if you’re running SQLBackupAndFTP in a restricted network, you can  look up SFTP To Go’s static IPs via the “Credentials” tab, then include them via your private-network firewall settings to gain access to SFTP To Go’s IPs.
Looking up static IP address via the SFTP To Go Credentials tab
Consulting with the Vulcan Science Directorate on optimal backup logic.

Schedule Backups:

  • Back in the “Jobs” tab, go to the "Schedule backups" panel.
  • Configure the schedule by setting the frequency and timing of the backups, then toggling the switch to “ON” or green state.
  • Your settings will now appear in text on the panel, as shown in the screenshot below.
Scheduled backup settings are visible via the SQLBackupAndFTP Job tab
Launching a class-1 probe to survey the cloud storage expanse.

Manual run and log:

  • Once configured. You can manually trigger a backup by clicking the green “Run Now” button in the top right corner of the “Job” tab.

Clicking Run Now To manually trigger backup via the SQLBackupAndFTP Job tab
Aligning the quantum resonators to stabilize the backup wormhole.

  • To view the scheduled and manual backup log, click “See Web Log” in the lower right of the screen.
  • A running log will look as follows.
Clicking See Web Log to view your backup log via the SQLBackupAndFTP Job tab
Energizing the backup conduits. All hands, brace for data transfer!

  • A successful backup log will look as follows.
Logs for successful backups indicate success in green via the SQLBackupAndFTP Job tab
Calibrating the universal translator for cross-platform compatibility.

3. In SFTP To Go

  • Once you’ve set up your backup and run it in SQLBackupAndFTP, you’ll have access to the SQLBackUpAndFTP backed up files via the file browser in SFTP To Go’s dashboard. The same is true for backups run via any other FTP client.
  • Contents are easily accessible, along with modification dates and sizes, by double clicking on your chosen folder.
Accessing backed up files via the File Browser tab in the SFTP To Go dashboard
Initiating a tachyon pulse to detect any temporal backup discrepancies.

In conclusion

By following these detailed instructions, you can quickly configure database backups using SQLBackupAndFTP and SFTP To Go.

This integration ensures that your databases are backed up securely and automatically, providing a reliable solution for database management and protection.

Cloud FTP with maximum security and reliability
SFTP To Go offers managed cloud storage service - highly available, reliable and secure. Great for companies of any size, any scale.
Try SFTP To Go for free!

Frequently Asked Questions

Where can I find the connection details in SFTP To Go?

Connection details are available under the “Credentials” tab in the SFTP To Go dashboard.

Which protocols are recommended for secure data transfer?

SFTP is recommended (and required) for secure, encrypted data transfer between SQLBackupAndFTP and SFTP To Go.

How can I ensure that the backup process is working correctly?

Regularly check email notifications and monitor the backup status in SQLBackupAndFTP to ensure that backups are being executed and stored successfully.

How do I start using SQLBackupAndFTP with SFTP To Go?

Begin by signing up for accounts on both SFTP To Go and SQLBackupAndFTP. Configure each according to your needs, ensuring that you have the necessary credentials and connection details.

What DBMS are supported by SQLBackupAndFTP?

SQLBackupAndFTP supports various DBMS like SQL Server, MySQL Server, and PostgreSQL Server, allowing for flexibility in database backup options.

Can I schedule automated backups using this integration?

Yes, SQLBackupAndFTP allows you to schedule backups, specifying the frequency and types of backups, which can then be securely stored in SFTP To Go.

What security features are offered by SFTP To Go?

SFTP To Go operates on secure protocols such as SFTP, FTPS, S3, and HTTPS, with static IPs, inbound network rules, and encryption at rest, ensuring secure data transfer and storage.

How can I monitor the status of my backups?

SQLBackupAndFTP offers email notifications, providing updates on the success or failure of backup processes. SFTP To Go also provides activity monitoring features.

Is it possible to restore databases easily from the backups?

Yes, SQLBackupAndFTP provides options to restore databases from the backups, ensuring that you can quickly recover data when necessary.

Where are the backups stored when using SQLBackupAndFTP and SFTP To Go together?

The backups are securely stored in the cloud storage provided by SFTP To Go, ensuring secure and reliable data management.

What kind of customer support is available for these services?

Both SFTP To Go and SQLBackupAndFTP offer customer support to assist with setup, troubleshooting, and any other queries or issues you might encounter.