Database Backup

Handy Backup features ability to backup databases that support Open Database Connectivity (ODBC) driver. The most popular ODBC compatible databases are Oracle, MySQL and MS SQL.

To back up these databases, follow these steps:

1. Launch the New Task Wizard.
2. Select Backup Task, and then click Next.
3. Click Add to open the shortcut menu. The list of available for backup items will appear.



4. Select Database. Data Source Selection window will appear.
5. Select File Data Source or Machine Data Source by clicking the respective tabs.

File Data Source is stored as a regular file on your local computer. Machine Data Source is stored as the system source in the System Registry.

6a.   On the File Data Source tab, click the Size arrow to select file data sources created earlier on your computer or remote computer. If there are no data sources for your database, create a new one. To learn more, refer to File Data Source.

6b.   On the Machine Data Source tab, select the desired data source from the list or create a new machine data source. To learn more, refer to Machine Data Source.

7. Select the desired data source, and then click OK. The data from the database will be added to the backup set.




Note: Handy Backup can only back up database tables. It cannot back up store procedures, views, functions, triggers etc from the database.



8. If you want to exclude one or several database tables from the list, expand the tree panel and uncheck the respective boxes.
9. When finished, click Next.

The subsequent steps are identical to usual backup task creation. For more details, refer to Backing up data.