Hot Backup for Database Content: The Highway to Effectiveness

Hot Backup

Handy Backup provides a function of hot backup, a technique of database backup when data moved to the safe place without stopping the database engine or interrupting user operations with the database content.

Download Handy Backup

Version 7.8.7, built on 2 December, 2016
65.0 MB

Hot and Cold Backup


An alternative method, called cold backup, operates with data when the database engine is stopped or the particular database is turned inactive, forcing all the processes to quit. Hot backup is a key to effective managing of every database safety.

Database backup manipulates often with tremendous amounts of data, paralleling and optimizing every step of workflow, so any little problem or delay can spoil an overall efficiency, causing time and financial losses.

Note: The solution allowing hot backup for databases as possible is always a preferable method of database backup.



Hot Backup Trivia

  • Hot backup is useful for medium or moderately large amounts of data when a lot of users or processes trying to get an access to these data simultaneously. Application of hot backup technique in this situation allows saving much time and money for database-depending business activity.

  • Cold backup is faster when a matter is a tremendous amount of different data needed to be stored in some safe place. Therefore, the cold backup is a method of keeping the database content for such actions as seeding or replication. See an example when a “cold” backup is the most convenient way - Jira backup.

For all daily activities, the preferred method of doing it is almost inevitable a hot backup.

Hot or Cold Backup


Database Hot Backup Using ODBC


Choose database to backup

ODBC standard of database driver is supported by now for almost all database types. ODBC drivers can operate for modern SQL-based systems as well as for venerable database engines. If the ODBC supports hot backup is a completely matter of that particular ODBC driver.

Handy Backup can work with every ODBC driver using the Database plug-in. Hot backup is completely possible when the ODBC driver allows it. No special actions are required; hot backup will be selected automatically if it is ever possible. To use the Database plug-in you must install the specific ODBC driver for your database firstly.



Recommended Solution

Handy Backup Small Server

Version 7.8.7, built on 2 December, 2016. 65.0 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Server

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


Using the ODBC driver and Database plug-in is a main method of backing up such databases as MS Access, Paradox DB and FoxPro. For more information about using Database plug-in for hot backup, please read about the ODBC backup technique.



Hot Backup Databases Directly


An alternative and much more effective way of hot backup is to use specialized plug-ins for most popular database engines provided by Handy Backup. These plug-ins are acting as bridges between database engine and the front-end user interface common for all Handy Backup tasks.

This way is somewhat more effective and quicker than using ODBC drivers. It also does not require to install anything other than a copy of Handy Backup with an appropriate plug-in included.


Database backup plug-ins

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


Handy Backup performs hot backup using plug-ins for such database engines as Oracle, MS SQL, MySQL, PostgreSQL, Lotus Notes/Domino and IBM DB2. Plug-ins automatically select hot backup when possible, automating the backup process without any disturbance for users (the hot backup task can even be executed as Windows service, hiding the interface completely).


Download Handy Backup

Version 7.8.7, built on 2 December, 2016
65.0 MB

Handy Backup can perform hot and cold database backup in a most efficient way, depending of user needs and overall organization of data processing.


You may also like:

0 comments

    Who uses our backup software?