Database Backup Software to Take DB Snapshots in Windows and Linux

Comments: 4

Database backup plays one of the most important roles in business disaster recovery plans. It provides confidence that in case of any problems with servers, no data will be lost, and recovery time will be reduced to the minimum. While there are many approaches to improving server availability (clustering, replication, partitioning, and other), none of them protect data from SQL injections and user mistakes, and therefore cannot replace backups.

Creation of valid database snapshots is probably the most complicated type of backup. In most cases it can’t be made by simple copying of the DBMS files, and requires you to use the database’s APIs to export its data. Handy Backup™ is a professional software that lets you back up and restore databases of different types (see a list of supported databases below). We welcome you to download and try the utility right now!

Version 7.4.7, built on February 18, 2014
22.9 MB, 32-bit (above) or 29.1 MB, 64-bit version

Contents [hide]

List of Supported Databases

Our software has an advanced modular architecture in which access to data is provided by plug-ins of different types. There are five database-specific plug-ins and one general plug-in suitable for all ODBC-compatible databases.

Database backup plug-ins

Database backup plug-ins: MySQL, MS SQL, Oracle, IBM DB2, Lotus Notes and ODBC

  • MySQL Backup. This plug-in connects to MySQL instance like a common client application and exports DB data into SQL dump files. Restoration of the backup is performed by consecutive execution of all SQL statements, i.e. the database is recreated from scratch. Read more about MySQL Backup...
  • MS SQL Backup. Microsoft-recommended method of backing up MSSQL Server is to use the combination of Window’s Volume Shadow Copy Service (VSS) and backup-related API provided by the DBMS, and that’s exactly how the plug-in works. To learn more, please see MSSQL Backup.
  • Oracle Backup. This plug-in is designed for backing up and restoring Oracle DBMS through native Oracle’s interfaces, which ensures accuracy and consistency of the backup. More about Oracle Backup...
  • DB2 Backup. The plug-in uses API provided by DB2 to store and retrieve data and log files. Read more about DB2 Backup...
  • Lotus Notes Backup. This plug-in creates recoverable backups of Lotus Notes databases by combining common copying of database files with advanced tracking of changes made during the copying. To learn more, please refer to Lotus Notes Backup.
  • ODBC Database Backup. Most databases used today (MySQL, PostgreSQL, MS SQL, MS Access, Oracle, FoxPro, DB2, etc.) comply with the ODBC standard which allows accessing DB via a set of standard functions. The plug-in uses ODBC connectors (drivers) installed on your system to export and import database tables. To learn about its advantages and restrictions, please see ODBC Backup.
Handy Backup Small Server

Version 7.4.7, built on February 18, 2014. 22.9 MB, 32-bit (above) or 29.1 MB, 64-bit version
Backup Software from Novosoft LLC. 199 USD per license.

Handy Backup Small Server

To make use of the database backup plug-ins, you need the Small Server edition of our software. You can try it for 30 days for free!

Cold and Hot Database Backup

There are two principal approaches to backing up databases:

  • 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.

  • Hot backup (also referred to as “logical 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. Learn more about hot backup...

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, weekly, monthly, or in your own period of time. Schedule backups, enable e-mail notifications – and always know that your data is adequately protected.

To learn about other features of our software and for instructions on planning database backups, please see Database Backup Features.

Version 7.4.7, built on February 18, 2014
22.9 MB, 32-bit (above) or 29.1 MB, 64-bit version

Backup vs. Replication vs. Clustering

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.

Though replication configuration provides higher uptime and accessibility of your databases, it cannot be considered a replacement for backups. If your Master database accidentally gets corrupted (due to an SQL injection or a user mistake), all the changes will be automatically replicated to Slave databases. Sometimes you can react fast and stop the replication procedure (which doesn’t require being made synchronously), and then use your Slave as a backup, but in most cases it is too late.

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 don’t allow for long-distance database distribution, but provide higher I/O speed and better response times.

As a general rule, it is always recommended to take the best of both worlds, and combine replication or clustering configuration and database backups.

Licensing Information

There are two business editions of Handy Backup, both come with a full line of database backup plug-ins:

Handy Backup Small Server
Handy Backup Network Server

To back up databases, try Small Server or Network Server editions. Free trial!

  • If you have only one database server, then you need Handy Backup Small Server
  • If you need to back up multiple servers, check out our enterprise backup solution that can back up up to 5 computers on a client-server scheme. See product page of Handy Backup Network Server

You can find pricing information on these and other editions in the Order section.

Video Example

In the next video you can see an example of database backup made with the MySQL Backup plug-in.

Note: To follow the instructions in the above video, you need to download our software.

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.

See Also

Enjoy one of the best software for database backup and recovery!

Version 7.4.7, built on February 18, 2014
22.9 MB, 32-bit (above) or 29.1 MB, 64-bit version

Loading comments, please wait...

4 comments

  • Paul | 2013-03-19 11:00:38

    I love this software. I recommend it to all my clients. Especially now that it has DVD burning which is great for most small business. I use it to back up inexpensive NAS's ... It keeps getting better!

  • birhead | 2013-03-19 10:57:16

    I liked the program because of its simplicity.

  • AlexHaven72 | 2012-10-22 05:51:14

    Is there a warranty on the backup database,and how to check whether database backup was successful?

  • HB_Moderator | 2012-11-12 05:35:46

    You may always check the destination folder to see whether all the files are backed up or not (however this information is visible in the log file). You can also create a test DB and check if Handy Backup is fully functional and works properly.

Contact Us

support@handybackup.net

sales@handybackup.net

+1 (707) 703-13-11

$199 per license

Upgrade to version 7

Volume Discounts
1 license$199 per unit
2-9 licensescontact us$199 per unit
10-49 licensescontact us$199 per unit

See all volume order prices

Join the Backup Community!

Related to Database Backup

Back up Database Server - learn specifics of backing up database servers of different types

Website Backup - back up your website with all scripts, images and database entries

Who uses our backup software?