ODBC Database Backup: How to Make Cold or Hot DB Snapshots

Database backup plays one of the most important roles in data protection. It provides businesses with confidence that in case of data loss, recovery time will be reduced to minimum.

Database backup is one of the most complicated areas of backup, because data used in Data Base Management Systems (DBMS) is constantly modified by many concurrent users and can’t be copied without stopping the service.

That’s why it requires the use of a hot backup technology, which allows copying data while preserving business activities. Download Handy Backup to get use of the hot database backup!

ODBC (Open Database Connectivity) is a standard of database interface independent of particular database engine. The special software called the ODBC driver is needed to use ODBC capabilities.

These drivers are easy to obtain for any one DBMS/DBME and are often free or open-source. The list of features supported depends completely from the particular ODBC driver.

Handy Backup can perform automatic backup through the universal Database plug-in operating with ODBC drivers, so all the features and limitations of the particular ODBC driver, including the possibility of "hot" backup, are supported.

• MySQL backup*
• MS SQL backup*
• DB2 backup*
• MariaDB backup*
• Oracle backup*
• PostgreSQL backup*

• SQLite Backup
• MongoDB Backup
• Sybase backup
• FoxPro backup
• Firebird backup

• Greenplum backup
• Interbase backup
• SAP HANA Database Backup
• Access database backup

Sample Feature: SQLite ODBC Backup

By using the ODBC plug-in, you can easily perform SQLite3 ODBC backup just after installing an appropriate ODBC database driver for Windows. Modern versions of this driver allow hot backup for SQLite ODBC solutions under Windows.

Handy Backup is a full-scale solution for all levels of backup including saving via ODBC. The Database plug-in used for these tasks has the following features:

• Hot backup. If an ODBC driver is capable of it, software can perform all backup activities without stopping the database server;
• Flexible scheduling and administering. By using Handy Backup, you can schedule any backup task to a regular repeating period defined from months to minutes. You can also run the application as Windows service and get all notifications through E-mail;

• Encrypting, compressing and preparing data for keeping. These are several settings that can help to keep data, include the strong encrypting, compression of saved copies, and the possibility to run some utilities before or after backup task;
• A plenty of devices for data keeping. Handy Backup allows you to move your copies of data to local, removable or network drives, FTP/SFTP/FTPS servers, private and commercial cloud services (including S3 and WebDAV-based clouds), and other solutions.

Handy Backup allows database backup not for network or corporate-level users only but to standalone computers as well. We are hope this approach to help all sorts of users organizing their backup workflow according to their specific needs!

In addition to the common ODBC-based Database plug-in, these are some specialized database plug-ins designed for Handy Backup. The key differencies of these plug-ins from the Database plug-in functionality are following: