> #### Database Backup jobs

> The job page and options to set up and run an online database backup are identical to an offline backup.

> To complete the Database Backup Properties page:

> 1. Provide values for the Name and Description.
> 2. From the list of available databases, select the database for which you want to perform this database backup.
> 3. Identify the backup device you are using:
> - If you select Tape, you must also define the absolute path for the tape device.
> - If you select Disk, you must also specify the directory and the filename. If you want to overwrite an existing backup at this location, select the Overwrite file option.
> 4. In the Volume size (-vs) field, identify the size, in database blocks, that you want the backup to be before prompting for another volume.
> If you select the Volume size (`-vs`) parameter, the following happens:

> - The Backup job looks for a file in your work directory with the name of `<resource name>-backup.txt`. This file should contain names for each backup file. If this file exists, the Backup job uses it as input to the OpenEdge Backup Utility (PROBKUP).
> The following figure shows an example `<resource name>-backup.txt` file:

>     e:\dbwork/ftd.bak1
>     e:\dbwork/ftd.bak2
>     e:\dbwork/ftd.bak3
>     e:\dbwork/ftd.bak4
>     e:\dbwork/ftd.bak5
>     e:\dbwork/ftd.bak6
>     e:\dbwork/ftd.bak7
>     e:\dbwork/ftd.bak8
>     e:\dbwork/ftd.bak9
>     e:\dbwork/ftd.bak10
>     e:\dbwork/ftd.bak11
>     e:\dbwork/ftd.bak12
>     e:\dbwork/ftd.bak13
>     e:\dbwork/ftd.bak14
>     e:\dbwork/ftd.bak15
>     e:\dbwork/ftd.bak16
>     e:\dbwork/ftd.bak17
>     e:\dbwork/ftd.bak18
>     e:\dbwork/ftd.bak19
>     e:\dbwork/ftd.bak20
>     e:\dbwork/ftd.bak21

> - If this file does not exist, the Backup job creates the file in the working directory. The file is the name of the backup (entered in Step 1) with a number from 1 to 99 appended to it. The Backup job uses this file as input to PROBKUP.
> - Any files created by the Backup job remain after the program ends. The Backup job does not delete them.
> 5. Complete the following fields:
> - Blocking factor (-bf) — Specify the blocking factor size used to flush buffers out of the backup device.
> - Redundancy factor (-red) — Specify the redundancy count to create redundancy in the backup.
> - Incremental overlap (-io) — Identify how many previous backups you want included in this incremental backup. Use this field simultaneously with the Incremental check box.
> - Incremental — Check this box to back up the blocks that have changed since the last backup. Use this field simultaneously with the Incremental overlap (-io) parameter field.
> - Estimate size — Check this box to generate a report that estimates the size of the backup.
> Note: This setting does not back up the database.

> - Verbose listing — Check this box to have Fathom provide output every 10 seconds concerning the status of the backup.
> - Compression — Check this box to indicate whether you want to compress data blocks as they are backed up.
> - No recovery — Check this box if you do not want the database to be able to roll forward an `AI` file. This option is used for mirrored backups.
> 6. Verify the name of the command's current working directory in the Working Directory field. If specified, this directory must exist. This property defaults to the working directory defined at installation.
> 7. To append subsequent messages to the `.out` or `.err` files, select the Append option. The Output file field indicates where messages will be retained.
> 8. Select the Debug log file option to obtain diagnostic details that help debug job properties when setting up a job. For example, you can set this option and use the Run Now feature on the Job Summary page. Once you have submitted the job, Fathom makes debug data available through the debug log file link on the Job Summary page.
> 9. If you intend to set up actions and alerts for this job, click the Edit button associated with the Completion Actions and Alerts field to display the Job Completion Actions and Alerts page. The Job Completion Actions and Alerts page appears. See the Resource Monitoring Guide for more information about the Job Completion Actions and Alerts page.
> 10. Click Save. The Job Summary page appears. You can now schedule the job or run it immediately. You can also edit advanced information. See the "Advanced information" section for steps on editing advanced information.

Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095