Databases hold the vital information that drives your business. If this data is lost or damaged, the continuity of your business will be damaged. For example, it is impossible to create profit without records of orders, deliveries, invoices, and payments.
Threats to continuity include environmental disasters that damage or lose the database. Other problems can be caused by accidental damage or loss. Disgruntled employees or malicious outsiders with access can change or delete data. All of these issues will imperil your business.
A core system security strategy is to prepare for adversity. For example, preparations to protect against database damage are pretty straightforward – back up the database.
Here is our list of the best database backup tools:
- N-able Cove Data Protection EDITOR’S CHOICE This backup and recovery service is a cloud-hosted SaaS platform and it can protect MySQL, SQL Server, and Oracle databases through integrations and other DBMSs through gfile backups. Clod storage is included in the price. Start a 30-day free trial.
- Vembu BDR Suite (FREE TRIAL) This on-premises package offers backup and recovery services for MySQL, SQL Server, and MS Exchange databases. It’s available in free and paid versions for Windows Server or Linux. Start a 30-day free trial.
- Acronis Cyber Protect (FREE TRIAL) This package of security services is delivered in the cloud and includes a range of backup options, including application-level backs for systems such as databases. Start a 30-day free trial.
- Ottomatik Protection for MySQL, MongoDB, and PostgreSQL databases delivered from a cloud platform.
- Iperius Backup This is an on-premises system that will protect Oracle, MySQL, SQL Server, SQL Express, PostgreSQL, and MariaDB databases. It runs on Windows and Windows Server.
- Quest Rapid Recovery This is an on-premises system that manages backup and recovery of SQL Server and Oracle databases. Available for Windows, Windows Server, and Linux.
- Commvault Backup and Recovery A cloud-based service that can manage local backups as well as those on the cloud, covering applications, such as databases or entire servers.
Database backup strategies
Backing up a database is as simple as taking a copy. However, you know that transactions are hitting your database all of the time, so copies frequently get out of date.
Backup strategies for databases rely on a play-off between completeness and performance.,So, naturally, copying every single transaction as it gets committed will slow down the response time of the database. However, leaving the backup refresh too long risks an event destroying a big chunk of business records.
The stance you take over the frequency of backup depends on the size of your business and the rate at which transactions occur. The traditional IT approach to backups involves backing up overnight when the office is closed, and there is no business activity and so no live perorations on the database. However, global businesses don’t have that luxury because there is always an office somewhere that is active. A business doesn’t need to be a large corporation to be globally active. Any website could be taking orders from anywhere in the world at any hour of the day or night.
How often should I backup my database?
Search on the Web for recommendations over backup frequencies, and you will see how quickly the world of IT evolves. You will see recommendations from 2015 and 2016 telling you to backup once a week (!!). A weekly backup strategy risks losing all data for the week. If you back up the database every Sunday, how much data would you lose if your server caught fire on a Friday?
A short-term solution can help you with a stop-gap, which is to write out transaction logs. These take less time to write out and, in most cases, just represent one more query on the database. Depending on the rate of change in your database, you can write our transaction logs every hour or every half hour.
With the cover of transaction logs, you can take a complete backup overnight. Then an incremental backup every 12 hours or every six hours. Finally, between backup actions, write out a transaction log every hour or half-hour.
As soon as a transaction log has been written, move it. You can write it to tape, to USB, or send it to a cloud directory. You will probably use both one local and one remote location. For example, if you write transaction logs every hour and perform a backup update every 12 hours, you will have 11 transaction log files. Once the update occurs, you can delete those files because the transactions they contain have been absorbed into the backup.
Transactions can be held in RAM (cache) for fast recovery. However, you need to be sure that the cache will endure a crash, and it won’t survive a physical disaster that destroys a server. Dumping that cache to a file periodically provides insurance.
Where should I hold my backups?
The location of backups is a factor that you can answer yourself through common sense. On the one hand, you need to be able to restore quickly, almost immediately if possible. On the other hand, you need to insure against environmental damage. A physical disaster on your site will lose you your backup as well as your original database.
The clear winner is to keep backups in two locations – locally for convenience and remotely for security. In addition to these two primary backups, you have your transaction logs. These should also be held in two locations – locally and remotely. Whether you keep both the primary backup and the transaction logs in the same place locally and remotely depends on the amount of confidence you have in your choice of backup storage provider.
If you don’t have confidence in the remote storage facility you use, you should probably look for another provider. Fortunately, most cloud platforms mirror contents over several data centers, so if your remote backup storage gets destroyed, it will be restored automatically.
The good idea is to adopt different strategies for backing up transaction logs to those used for the primary database backup. For example, you can write transaction logs to a directory with automatic syncing with a cloud server. Thus, your transaction logs will be saved and restored automatically.
How should I manage database backups?
Even very technically competent staff have plenty of tasks to occupy them and probably don’t want to spend too much time backing up the database. However, they would soon pay attention if a disaster occurred and data needed to be restored.
Recovery is only possible if backups are performed satisfactorily. Therefore, the tiresome task of backing up frequently cannot be overlooked. Fortunately, mundane, scheduled tasks are what software is very good at. Thus, the strategy that you need to adopt over database backups is to automate the process.
Database backup tools will take care of the data recovery process. Restoring data isn’t just a question of repopulating tables. The structure of the database changes over time, so continuity requires database objects to be stored and their contents.
The best database backup tools
Backing up a database isn’t as straightforward as copying over files. A database tool needs to get inside the database and extract all of its structures – its metadata – as well. That strategy can be implemented in many ways, so there are several different approaches that database backup tools employ.
Our methodology for selecting a database backup tool
We reviewed the market for systems to backup databases and analyzed the options based on the following criteria:
- A backup system that covers transaction logs as well as the database itself
- A service that can manage recovery from the cache
- The ability to manage backups locally and remotely
- A choice of tools that will run locally or as SaaS platforms
- Security for access control and also to protect stores from hackers or malware
- A free trial or a demo account for a no-obligation assessment
- Value for money represented by secure tools that will not fail offered at a reasonable price
We have identified some very reliable database backup and recovery systems that will quickly restore lost data with this set of criteria in mind.
You can read more about each of these options in the following sections.
1. N-able Cove Data Protection (FREE TRIAL)
N-able Cove Data Protection is a SaaS platform for backup, recovery, and replication. It supports MySQL, SQL Server, and Oracle databases. The package includes automated systems to manage backup and recovery and also cloud storage space. Both data transfers and storage is protected by AES-256 encryption, and the storage is mirrored on another data center to prevent loss in the cloud.
Key Features:
- A cloud-based SaaS package: Suitable for IT departments and managed service providers
- Choice of storage strategies: Store locally, on a remote site, and on the provided cloud storage
- File backup or whole disk image: Cloud-to-cloud for SaaS platforms
Why do we recommend it?
N-able Cove Data Protection is a backup and recovery package that is hosted in the cloud and includes cloud storage for repositories. This package also includes mechanisms to archive backups, allowing multiple rollback points to be retained at little cost. This package can perform disk copies and file-level backups but not application-aware backups.
The N-able database backup system offers hot and warm backups, which can run while the database is still live and serving users. The backup gives you a complete copy of the database. So it can be used to replicate database instances in new locations or create copies for testing and development purposes. The system can also facilitate migration to a different platform, such as moving to the cloud.
Who is it recommended for?
The N-able brand is designed for use by managed service providers. So, this tool is produced in a multi-tenant architecture. IT departments can also use Cove Data Protection but they just wouldn’t create the sub-accounts that MSPs need to separate the data of their clients.
Pros:
- Secure operations: 256-bit AES encryption for transfers and storage
- Backup entire disks or files: Backup for virtual systems as well as physical servers
- Regular backup: Setup backups to run every 15 minutes
Cons:
- No price list: You need to ask for a quote
Other options from N-able Cove Data Protection include entire server backup for Windows Server and Linux, which would also cover your databases. Additionally, there is a multi-tenanted option available for managed service providers. N-able Cove Data Protection service is available for a 30-day free trial.
EDITOR'S CHOICE
N-able Cove Data Protection is our top pick for a database backup tool because it integrates with MySQL, SQL Server, and Oracle to extract data for backup directly from the database. You can make a backup of data while users are still no the database and there is no need to bounce the system in order to get data back into the database in the event of data loss. The transfers and storage for this package are protected by 256-bit AES encryption and that storage space is included in the price. All accounts on the N-able cloud servers are mirrored, so they are automatically backed up to ensure against disaster. Back up files, entire servers, virtual systems, and cloud accounts with this package. The system is delivered from the cloud in a multi-tenant architecture for use by managed service providers and it is also a good choice for in-house IT support teams.
Download: Get a 30-day free trial
Official Site: https://www.n-able.com/products/cove-data-protection/trial
OS: Cloud based
2. Vembu BDR Suite (FREE TRIAL)
Vembu BDR Suite offers backup services for SQL Server, MySQL, and MS Exchange databases. The BDR system is a family of tools for specific resources. There is also a version for VMs that has a free version that package is able to backup databases as well. The free tool is limited to backing up 10 VMs.
Key Features:
- On-premises software: For Windows Server and Linux
- Application-aware backups: Backup for Microsoft products
- Database backups: For SQL Server and MySQL
- Incremental backups: MySQL backups operate through data dumps
- Microsoft integration: The backup system has direct access to data in SharePoint, Exchange Server, and SQL Server
Why do we recommend it?
Vembu BDR Suite is offered in six editions and one of those covers databases. That edition is called Application-level Backup. It backs up Microsoft Exchange Server, SharePoint, SQL Server, and MySQL. The tool is available as a SaaS platform but you can also get it as a software package for self-hosting.
The BDR Suite’s database instance backups can be used for replication and migration as well as for recovery.
The service extracts all database objects and data with a dump. That file is stored locally and the Vembu backup management system can read the contents, reformatting it into a list of tables. This gives you the option of restoring specific tables and their data rather than the whole database. However, whole database recovery is also an option.
Vembu copies that backup file to a remote repository of your choice. The storage space for that remote store isn’t included in the plan price but it is available on the Vembu Cloud server for a fee.
Vembu BDR Suite offers a range of strategies and it has native support for SQL Server, MySQL, and MS Exchange Server databases. You can deceive to recover just an individual file or an entire instance with this service. The on-premises Vembu system is offered in multiple editions and this provides a number of other options to backup your database. For example. The Windows Server Backup edition will take our database files along with all other data held on your server. There is also a SaaS version of this database backup service available, called Vembu Cloud BDR Suite. The cloud version includes storage space on the Vembu servers
Who is it recommended for?
Vembu’s flexibility with its SaaS platform and on-premises option gives it wide appeal. The application-level package is one of the most expensive packages in the Vembu BDR Suite. The software version is available for Windows Server and Linux, which also means that there are almost no businesses that wouldn’t find Vembu BDR suitable.
Pros:
- Copies database data to files: These can be processed for backup
- Applies compression: Saves storage space
- Protects data with encryption: Uses 256-bit AES encryption to protect data during transfers and in the repository
- Multiple editions: Other BDR suite plans cater to server backup servers, endpoints, VMs, and cloud systems
- A cloud-based SaaS version is available: This is called BDRCloud
Cons:
- Cloud storage space isn’t included: Vembu offers a cloud storage system for a fee
Vembu BDR Suite is available for Windows Server and Linux. Vembu offers a demo of the BDR Suite and you can also get the database backup system for a 30-day free trial.
3. Acronis Cyber Protect (FREE TRIAL)
Acronis Cyber Protect is a cloud-based platform that offers a range of security systems. Among these is the Acronis Backup service. The backup system can be applied at file level, to copy an entire disk, or on a per-application basis. This tool is able to back up implementations of a range of database management systems.
Key Features:
- Editions for different business types: Home office, small business, regular business, and MSP
- Includes an antivirus package: Ideal for ransomware protection
- Scans files before copying them to the repository: Provides constant virus protection as well
- Backs up multiple platforms: Protects data on devices running Windows, macOS, Linux, iOS, and Android
Why do we recommend it?
Acronis Cyber Protect is a combination package that provides both antimalware and backup services. First and foremost, this is the perfect combination of services to beat ransomware. This system offers whole disk imaging and file-level backups. It doesn’t provide application-aware backups, so, you would create a periodic dump and backup that file together with transaction logs.
The easiest way to back up your databases is to store transaction logs and cache dumps. With these sources, databases can be easily recreated after a catastrophic loss. System administrators have a choice of where to set up a repository. It can be held in different formats in different locations simultaneously.
The tool will scan files for infection before uploading them to the repository. The combination of anti-malware and safe backup makes Acronis Cyber Backup the ideal tool to combat the threat of ransomware.
In summary, Cyber Protect adds many system protection features as well as its backup service. The package includes anti-malware for endpoints and also a patch manager. This system can backup desktops, laptops, servers, file systems, and mobile devices. This package is delivered from the cloud, which makes it easy to monitor assets on many sites in one account.
Who is it recommended for?
This tool is available in a number of editions that are suitable for different target markets. As well as versions for each business size, there is a home-use version and a package for managed service providers. This is a great service for all-round system backups but not so hot for databases.
Pros:
- File backup: Take a cache dump and transaction log of any database for backup
- Choose your backup locations: Store locally and to cloud storage
- Cloud storage: Plans with and without cloud storage
- A SaaS package: Delivered from the cloud
Cons:
- Not application level: You need to extract database data into files and back those up
Acronis Cyber Protect is available in five editions. You can assess the package with a 30-day free trial.
4. Ottomatik
Ottomatik is a SaaS system that includes a range of backup services, including database backups. The service provides coverage for MySQL, MongoDB, and PostgreSQL databases, and it provides an optional cloud storage service to support those functions.
Key Features:
- A cloud-based system: A SaaS package
- Database backups: For MySQL, MariaDB, MongoDB, Supabase, and PostgreSQL
- File backup option: Extract data to files and back them up for databases not directly
Why do we recommend it?
Ottomatik provides backups for whole disks, for files, and for databases. The DBMSs that this system will cover are MySQL (and MariaDB), PostgreSQL, Supabase, and MongoDB. You can look at the database contents for testing and comparisons between versions before restoring.
The primary method used for database backups is the database dump. You extract structures and records into files and then transfer those files. There is also a regular file backup service, which would cover your transaction logs.
The user can attach an existing account with Dropbox, AWS, Backblaze, or Google Drive. Those who don’t already have an account with one of those platforms can take out an Ottomatik storage account on a separate subscription.
Who is it recommended for?
Ottomatik doesn’t include storage with its plans so you choose your own cloud and local stores. However, Ottomatik offers its own storage servers as an option for an extra fee. The tool has quick setup features to simplify onboarding but these can all be tweaked and improved on later once you become familiar with the command set for Ottomatik.
Pros:
- Backup frequency options: Daily, every five minutes, or every minute, depending on the chosen plan
- Free plan: with 1 GB of cloud storage included
- Local backup possible: Or choose to save to your own cloud account
Cons:
- Free edition limitations: Only backs up once a day
The Ottomatik service is available in four plans. That range makes the system attractive for businesses of all sizes. Subscriptions are available for monthly and annual payments with the yearly rate the equivalent of a 10-month charge. All plans are available for a 14-day free trial.
5. Iperius Backup
Iperius Backup covers SQL Server, MySQL, MariaDB, Oracle, and PostgreSQL databases. This package can also perform whole server backups and offers coverage for applications, such as virtualizations and Microsoft 365. This is an on-premises solution that requires the installation of the server module on at least one computer on your network.
Key Features:
- Database protection edition: MySQL, MariaDB, SQL Server, Oracle, and PostgreSQL
- One time payment: Buy the software outright
- Priced per host: Backup unlimited servers
Why do we recommend it?
Iperius Backup is available in five editions, which include one for database backups and another that includes the functions of all of the editions, so it also includes database backups. The package can back up SQL Server, SQL Express, MySQL, MariaDB, PostgreSQL, and Oracle. This is a software package for Windows Server.
Each computer that hosts a database will need an agent program installed on it. These agents provide local services coordinated by the server, where you set the variables of your backup strategy.
A system forensic data recovery service is included in the Iperius Backup plans. This is called Iperius Recovery Environment, which can scan damaged operating systems and reassemble broken file pointers. Iperius offers four plans, and only the top two of these, called Advanced and Full, include database backups.
The server of Iperius Backup installs on Windows Server. Its primary backup strategy is to transfer everything up to cloud storage. You can attach your cloud storage account or take out a subscription to the Iperius Cloud storage system. Backup files can be compressed to speed data transfers in both directions, and all transmissions are encrypted for security.
Who is it recommended for?
The service is an on-premises package but it can also backup systems running on cloud platforms. You can choose to back up a whole disk right down to and including the operating system, get file-level backups, or application-aware backups. All of these options would backup your databases. Choose your own storage location.
Pros:
- Local and cloud backup: Design your own strategy
- Full disk backup or file copy: In addition to database backups
- File synchronization option: Provides an easy backup strategy
Cons:
- Storage space not included: This is a software package that you manage yourself
There is a free version of Iperius Backup, but that doesn’t include database coverage. You can get a 21-day free trial of Iperius Backup.
6. Quest Rapid Recovery
Quest is a solid and reliable brand, and Rapid Recovery is an excellent choice to back up SQL Server and Oracle databases. The front end of Quest Rapid Recovery is called AppAssure, and the data extraction and transfer service are called ZeroIMPACT. Although these two elements have their brand names, they work together as an integrated package. The service will also backup transaction logs.
Key Features:
- On premises software: Runs on Windows and Windows Server
- Backs up SQL Server and Oracle: Direct access to the database
- Whole disk or file copy options: Useful for DBMSs other than SQL Server and Oracle
Why do we recommend it?
Quest Rapid Recovery is an on-premises software package that will run on Windows and Windows Server. This system will back up SQL Server, Oracle, SharePoint, and Microsoft Exchange Server. As well as application-aware backups, you can take a clone of a whole disk. This service can be used for migration as well as recovery to the original location.
Quest Rapid Recovery can cover entire servers as well as applications. So, you could opt to backup your server, including the database. However, as this is an incremental service, it won’t copy over much of the other data on your server each time because it only takes copies of changes. Other applications that can be backed up individually with Rapid Recovery include Microsoft Exchange Server and SharePoint.
Both backup extraction and data restoration run while the database is live and serving users. The recovery will prioritize data that is being demanded by searches that users launch. The push of data replacement will prioritize those demands and operates quickly enough that users might say that response is a little slow rather than unacceptable.
Who is it recommended for?
The Quest system is great for you if you run SQL Server or Oracle databases. The backup system uses deduplication and compression to save storage space. As the storage server isn’t included with this on-premises system, you need to decide on your own locations – such as a local store and also a cloud storage plan.
Pros:
- Multiple technologies: Backs up physical, virtual, and cloud systems
- Deduplication: Reduces storage requirements
- GDPR-compliant: Data privacy and security
Cons:
- Not a SaaS package: Sort out your own storage locations
Quest Rapid Recovery runs on Windows, Windows Server, and Linux. In addition, quest offers Rapid Recovery a 30-day free trial.
7. Commvault Backup and Recovery
Commvault Backup and Recovery is part of a suite of system management tools, called Commvault Intelligent Data Service, which is a cloud platform. Administrators access the Command Center dashboard through any standard Web browser to manage their backup strategies. This system can be used to back up individual applications or entire servers. Specifically, you can backup MySQL, Oracle, PostgreSQL, and DB2 databases with this product.
Key Features:
- Choice of backup strategies: Whole disk or file-level backup
- Compatible with some DBMSs: Use file backup for non-compatible systems
- Storage location control: Store locally and on the cloud
Why do we recommend it?
Commvault Backup and Recovery includes ransomware protection and it encrypts data for transfers and in storage. This system is able to back up and restore any platform, including your endpoints, containers, cloud platforms, and VMs. This tool will cover databases run on Oracle, PostgreSQL, DB2, and MySQL. As MariaDB is so similar to MySQL it works for that DBMS as well.
The Commvault backup system gives you options over where your backups are held. You can manage local, on-site backup repositories through the web-based console and extract your cloud backup from that, so you can decide to backup your backup. This double backup strategy gives you the speed of recovering from a local store and the security of preserving your databases in the event of an environmental disaster on your premises.
The backup system can also protect your cloud services, so this is a hybrid system protection service. It will cover virtualizations and containers as well. This system is also able to manage archiving that will save you money on the cost of long-term storage. All files are scanned for ransomware before being added to the backup repository.
Who is it recommended for?
This is a good solution for mid-sized businesses. The package is very flexible in that it can backup databases and files that are on just about any operating system or platform. That gives the tool a very wide potential customer base. You can also take complete copies of drives.
Pros:
- A cloud-based system: A SaaS subscription service
- Includes malware protection: Suitable for protection against ransomware
- Application-level database backup: Compatible with MySQL, MariaDB, Oracle, PostgreSQL, and DB2
Cons:
- Doesn’t backup SQL Server: You will need to use file backup on data extracts for SQL Server
Commvault Backup and Recovery is offered as part of the Commvault Disaster Recovery package, which you can examine with a 30-day free trial. Another option to get the Disaster and Recovery service is to choose the 30-day free trial of Commvault Complete Data Protection.
Database backup FAQs
How do I backup my database?
There are two ways to back up a database. The first is to locate the files to which your DBMS stores data. There is probably a periodic store of the database and then threw will also be transaction logs, which show every data change within the database. The other method is to run a script within the database to create a straightforward dump of all contents. Database structures are usually created by scripts for migration. If you have those files, then backing them up will save them and allow you to completely recreate the database structures.
What are the 3 types of backups?
There are three backup strategies:
- Full backup
- Differential backup
- Incremental backup
A full backup takes a complete copy of the database and this will also occur periodically with differential and incremental backup strategies. With a differential backup a series of minor backup events take place between full backups. These copy over all of the data that has changed or been added since the last full backup. An incremental backup copies new and changed data since the last full or incremental backup.
What is the best data backup method?
The classic backup strategy is called the 3-2-1 rule. This means that you should have three copies of the backup, held on two different media, and have at least one copy on a cloud platform. For example, make a local copy and store it on a server, then write a copy of that to tape and send another copy to cloud storage.
