Additional Backup Set Options | The options in this section are specific to the type of backup set: |
Backup set options | |
Use buffer | If checked, files will be copied to the DS-Client Buffer (i.e. as fast as possible for the given server and LAN speed). This will free up the backup source as fast as possible. Then the DS-Client will send the files from the DS-Client buffer to the DS-System. |
Detailed log | Records all files that are backed up (you can view them in the Activity Log). |
Stop on errors | Select this box to set an error limit, at which a backup will be stopped. Enter the maximum number of errors in the Stop on Errors box to the right. |
Start at | Leave this box blank to start the demand backup immediately. Enter a time, if you wish to delay starting the demand backup until the time specified. |
Instant Recovery | If selected, this backup set will send a copy of the backup data to the configured instant recovery location connected to the DS-Client. |
PreScan | Performs a PreScan of all files in the backup set to estimate a time for completion of the backup. |
Additional Backup Set Options | MySQL backup sets. |
Add locks around insert statements | Lock tables before inserting data on restore. (See the MySQL manual page for ’mysqldump’ for more information.) |
Lock all tables for read | Prevent changes to data while backup is in progress. (See the MySQL manual page for ’mysqldump’ for more information.) |
Add MySQL specific table create options | Add MySQL specific extensions to the backed up database dump. (See the MySQL manual page for ’mysqldump’ for more information.) |
Insert statement type | Specify how table rows are inserted into the database dump (i.e. the style of the 'INSERT' statement). (See the MySQL manual page for ’mysqldump’ for more information.) • Extended - Fast insert. Might not be useful for manual loading into non-MySQL databases. • Complete - Uses complete ‘INSERT’ statements that include column names when inserting rows. • Normal - Standard insert. Slower, but can be more portable to other databases. |
Additional Backup Set Options | PgSQL backup sets. |
Backup only the schema, not the data | Dump only the schema (data definitions). |
Do not backup privileges (Grant / Revoke) | Will backup only the data, not including the privileges of the database. |
Backup data as INSERT, rather than COPY | Dumps data as INSERT commands (instead of COPY). This will make restores very slow, but it will make those backups more portable to other SQL database packages. |
Additional Backup Set Options | Oracle backup sets. |
Logical Corruption Check | (Default is on) Will perform a corruption check on the database prior to backup. |
Backup only current archived logs | Select to backup only those logs that are necessary for the Oracle database. This saves backup space, by avoiding backup of any older logs. Leave this box cleared if you want to backup all log files |
Truncate archived logs | Clear the Oracle Database logs associated with this item after backup. |
Additional Backup Set Options | DB2 Server backup sets. |
Prune History / Logfile | Delete entries from the history file or log files from the active log path. |
Online Backup | • If cleared, perform Offline DB2 backup. During an offline backup, applications cannot connect to the database. • If checked, perform Online DB2 backup. An online backup allows applications to connect to the database and read and write to tables during database backup. Log retain or userexit must be enabled for an online backup. |
Additional Backup Set Options | SSH backup sets. |
Do not follow the Mount Point | Select to backup only the Mount Point itself (not the data under any Mount Point). |