Backup Ninja vs. The SQL Backup and FTP Solution

Backup Ninja vs. The SQL Backup and FTP Solution

Profile picture for user LukasVileikis
Lukas Vileikis
24 June 2021

The SQL Backup and FTP software is a pretty good tool in the database world. The software offers a couple of tiers (including a free tier), each of them consisting of different features. The software is frequently used together with SQL Server, MySQL and (or) PostgreSQL database instances to back up their data. In this blog post we are going to go over some things that this tool can do that compare with Backup Ninja’s offerings.

Why Backup?

Before actually telling you how does Backup Ninja compare with the SQL Backup and FTP solution, we should probably tell you why you should back up your data in the first place. In general, backing up your data allows you to:

  • Sleep soundly at night - when your data is properly backed up (meaning backed up and tested, so you are sure it’s actually working), you can make sure you always have a copy of your data at hand whatever happens.
  • Avoid having headaches regarding your database safety now or in the future - you will need to worry less about your data being lost, corrupted or even getting hacked. When you have backups and you ensure that they can be recovered, you’re in good hands.
  • Put your business at less risk - if your business-critical data is lost, it might mean that it’s game over for your business. You might lose customers due to downtime, or even worse, be at risk of complete shutdown of your business.

Now that you know why you should perform backups regularly, we should probably get into the SQL Backup and FTP and Backup Ninja offerings.

What can SQL Backup and FTP Offer Your Business?

As already previously mentioned, SQL Backup and FTP can offer you a bunch of services including backups of your SQL Server, MySQL and PostgreSQL instances without interrupting the flow of your database processes, it can let you backup an unlimited number of databases, it allows you to store the backups of your database instances in the cloud or other solutions (FTP, SFTP, FTPS, Network Attached Storage devices, folders that can either be local or on a certain network etc.), it can also help you backup your business critical data residing in Azure or Amazon deployments, with it you can also quite easily setup log shipping.

Why Would You Use Backup Solutions?

As you can probably tell by now, SQL Backup and FTP could be useful in a multitude of situations and scenarios - especially if your backup processes involve open source databases. However, what you also need to understand is why, as a DBA or a developer, would you use such solutions in the first place? You can just take your database backups by hand, right?

Well, there’s that, but you also need to remember that if you have a multitude of databases (perhaps MySQL, PostgreSQL, MariaDB, MongoDB, Percona or TimescaleDB), you would not really have time to back all of the data existing in those database instances manually. Here’s where the aforementioned tools come in handy because they enable you to quickly, simply & securely take and manage your database backups, no matter what kind of database infrastructure you use. We will now cover what Backup Ninja can do in that scenario, then tell you how it compares with SQL Backup and FTP.

What can Backup Ninja do For Your Business?

As already previously mentioned, Backup Ninja is a simple, secure and cost-effective Backup-as-a-Service solution that can help your business stay afloat and take care of your backup needs. Backup Ninja supports multiple database technologies including MySQL, PostgreSQL, MariaDB, MongoDB, Percona and TimescaleDB, and the core features it can offer can be accessed once you log in to your Backup Ninja account - here’s what you will most likely see (we have two servers, one running and one inactive, if your statistics are different, the page can look a little bit different too, but the core premise is the same):

Backup Ninja UI

As you can see, Backup Ninja offers you a bunch of options to choose from on the left hand side - you can get an overview of the backups happening in your database servers, configure backup schedules, review notifications or billing, setup backups in the cloud or the activity log. You can, of course, also always reach out to support or read the documentation if you so desire too.

Backup Ninja can also provide you with a list of the backups that are running on your different database instances - backups can then be restored or deleted:

Backups

You can also view a list of scheduled backups if you so desire:

Schedules

Or even schedule a backup yourself - in this case, there are quite a bunch of settings you can modify including enabling or disabling Point in Time Recovery (PITR), backing up a database per file, selecting a server to perform the backup on, choosing the backup method or backup type, choosing a local or cloud storage solution etc.:

Details

Backup Ninja also lets you observe the list of servers that you have while also providing you with their status, percentage of storage used, when was the backup last seen or created at, you can schedule a backup of them, also you can restart, upgrade your agents or remove a certain server altogether:

ServersModifying Backups

Backup Ninja also allows you setup email notifications - that way you can be notified when backups are created, when they fail or are removed, once they complete with errors, you can receive certain notifications regarding backup scheduling too:

Email Notification Settings

Backup Ninja can also provide you with a thorough user activity log letting you know who logged in to your account and when (this page also shows IP addresses, though they are censored for privacy reasons):

User Activity Log

Backup Ninja also has a bunch of other features, some of which compete with the SQL Backup and FTP solution mentioned before in this blog post.

How can Backup Ninja Compare with SQL Backup and FTP?

Now that you have a little more understanding of how both SQL Backup and FTP and Backup Ninja work and function, we should tell you how Backup Ninja can compare with SQL Backup and FTP. Here are the key differences between the two offerings:

  • SQL Backup and FTP can only back up SQL Server, MySQL and PostgreSQL database instances - Backup Ninja can back up MySQL, PostgreSQL, MariaDB, MongoDB, Percona and TimescaleDB database instances.
  • Both SQL Backup and FTP and Backup Ninja have a free tier, though SQL Backup and FTP lifetime license costs $499 at the time of writing - if you need a cheaper backup option, Backup Ninja may be the way to go.
  • SQL Backup and FTP only allows you to send backups to Amazon S3 on its higher priced tiers - Backup Ninja can allow you to do that for way cheaper.
  • SQL Backup and FTP only offers backup encryption at its higher priced tiers too - Backup Ninja can allow you to do that for a cheaper price as well! Just check the advanced end-to-end security page on Backup Ninja and see for yourself.
  • SQL Backup and FTP also only allows you to only run differential backups only when certain (expensive) plans are in use - Backup Ninja offers a free tier that unlocks all of its capabilities, plus its plans are cheaper should you decide to pay for the service.

Summary

Both Backup Ninja and SQL Backup and FTP are good backup solutions if you want to back up your open source databases either locally or in the cloud. However, remember that SQL Backup and FTP is generally more expensive, has less features than you would probably need, and Backup Ninja can offer backup solutions for more database management systems

Tags