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!
Database Backup via ODBC
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.
* Databases marked by asterisks can be backed up also through specialized plug-ins. Specialised plug-ins can work without ODBC drivers. See the information about specialized plug-in advantages over the generic Database plug-in below.
As many database engines does not support native backup tools, the need for the universal software utility capable to backup just any single database is strong. The list of ODBC for different databases you can find here.
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.
Version 8.4.2, built on September 19, 2022. 111 MB
The Small Business offers you a handy set of features, including different hot database backup software options and advanced security (FTPS and SFTP support). Free 30-days trial version!
Database Plug-in Features
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:
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!
Using Database Plug-in for Moving Data via ODBC
To use the Database plug-in correctly please perform following steps:
For detailed instructions, please read the User Manual section about the Database plug-in.
Specialized Plug-ins vs. Generic Database Plug-in
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:
It is almost the universal rule that specialized plug-ins can serve more effectively than the basic Database plug-in. However, for some cases, this rule not works, and backup operations through the Database plug-in can be more effective economically or logically than distributed plug-ins.
The final choice is only a matter of user-defined strategy, not of financial or technical restrictions.
Handy Backup: professional yet cost-efficient software for database backup and recovery!