Database Backup Software to Take DB Snapshots in Windows and Linux
Database backup is a crucial part of business-level data security procedures. To take snapshots from every database existed, Handy Backup provides a couple of generic and dedicated tools allowing to backup database without any significant efforts or expenses.
Handy Backup is a professional-grade software providing database backup and recovery for different DBMS types. Along with databases, Handy Backup can save data of any other types, from files and folders to static website contents, CMS data and cloud accounts!
Download Free
Version 8.5.0 , built on September 19, 2023. 116 MB
30-day full-featured trial period
List of Supported Databases
This instrument takes snapshots of MySQL databases and tables, forming readable sets of SQL commands allowing restoring original MySQL datasets.
The dedicated instrument can back up Microsoft SQL Server of any version (MSSQL 2016, 2014). This tool can save whole databases, tables, SPFILE and Controlfile.
Handy Backup uses a dedicated instrument to back up PostgreSQL databases, tables and schemas, allowing backing up local or distributed PostgreSQL databases.
The Oracle backup feature bases on a RMAN internal backup utility, providing a complete compatibility with an Oracle API. It can back up & restore Oracle data natively.
The MariaDB backup feature allows users creating and restoring a sequence of MariaDB SQL operators, restoring a table backed up. Like MySQL, it supports many engines.
The IBM DB2 backup plug-in is a solution allowing creating hot and cold DB2 snapshots, as well as restoring and replicating DB2 databases in a native API mode.
The plug-in for backing up IBM Notes (formerly Lotus Notes and Domino) files and tables allows quick and secure access to IBM Notes database information and effective restoration for taken snapshots.
Cacti backup with Handy Backup software is very easy and highly efficient, due to its MySQL plug-in.
Generic Tool Using ODBC - Database
Use an ODBC database backup for any DBMS existed with a standard, generic instrument called “Database”. With such a feature, you can back up some SQL or non-SQL databases:
- Sybase backup – saving a popular SAP database structures locally or on a server.
- Firebird Backup Database - safekeeping copies of different Firebird databases.
- FoxPro Backup - saving table content from the ever-popular desktop DBMS.
- MS Access backup - taking snapshots of the popular database from Microsoft Office.
Hot and Cold Database Backup
There are two principal approaches to backing up databases:
- Hot backup is a type of copying that is made through the use of database’s APIs. It is slower than cold backup, but doesn’t require stopping the DBMS server and allows making transaction-safe database snapshots while preserving business activities.
-
Cold backup requires you to stop your DBMS and let it dump all data from the memory to hard disk, after which you can back it up via usual file system copying. While this method results in server downtime, there are situations in which it can work exceptionally well.
For example, if you have a Master-to-Slave replication configuration, then you can safely turn off the Slave, back up its files, and then start it again.
All database backup plug-ins in Handy Backup are designed to retrieve data without interrupting database services, i.e. perform hot backup. The program can be used on both physical and virtual servers, and all operations can be scheduled to run daily or in your own period of time.
Schedule backups, enable e-mail notifications – and always know that your data is protected.
Replication and Clustering
Replication
Replication enables you to distribute the database across several servers and assign each server its own role, so that one server interacts with applications in a common way, while the others are used as read-only copies.
Failure of one server doesn’t cause complete loss of service of your applications, and at any time you can reconfigure a Slave Server to act as a Master and vice versa.
Note: Though replication configuration provides higher uptime and accessibility of your databases, it cannot replace backups. Therefore, if your master database will accidentally crush, then all changes will be automatically replicated to slave databases.
Clustering
The same is true for clustering configuration where multiple servers (SQL nodes) act as one, without any specific roles. Clusters are usually based on distributed storage engines in which failure of any node doesn’t result in any loss of data.
Unlike replication configuration, they do not allow for long-distance database distribution, but provide higher I/O speed and better response times. As a rule, it is always recommended to combine replication or clustering configuration and database backups.
Licensing Information
There are the two business-level editions of Handy Backup, both come with a full set of database backup plug-ins and other useful options. To back up databases, try either Small Business or Server Network editions. Free 30-day trial!
Recommended Solution
$249 per license
Handy Backup Small Business
To make use of the database backup plug-ins, you need the Small Business edition of our software. All plug-ins for data sources and storage for small business server backup!
Recommended Solution
from $299 per license
Handy Backup Server Network
Make centralized backup of all servers and workstations in an entire network from one centralized console by using the Server Network edition, a complete solution for network backup!
Video Example of Database Backup
In this video you can see an example of database backup made with the PostgreSQL plug-in. You will learn how to save and restore PostgreSQL tables by using all features of Handy Backup step by step.
Handy Backup for Hosting Providers
We are a very open company, and look forward to partnership opportunities with businesses from all fields of IT, including OEM, service providers, integrators, and other. Our solutions are already used by several web hosting providers who use it to back up databases of their clients.
If you would like to join our partner network, or discuss details of potential co-operation, please refer to the Partners section.
Download Free
Version 8.5.0 , built on September 19, 2023. 116 MB
30-day full-featured trial period
Enjoy one of the best software for database backup and recovery!
See Also:
Cnet Editor’s Rating:
Outstanding