Application settings for database maintenance

You can manage the Backup Exec Database and the Desktop and Laptop Option (DLO) database.

See Configuring database maintenance.

Table: Application settings for database maintenance

Item

Description

Enable Backup Exec database maintenance

Activates the database maintenance process.

Last time maintenance was performed

Indicates the date and time the last database maintenance was performed.

Perform database maintenance at

Indicates the time you want to perform database maintenance. All the maintenance will occur once a day at the time you specify.

Delete aged data

Activates the deletion of expired job history, job logs, alert history, and reports from the Backup Exec Database after the specified number of days have passed.

For the Desktop and Laptop Option (DLO) database, only the Alert History setting applies. DLO does not have job history, job logs, or reports.

Keep job history for data on media that have current overwrite protection periods

Keeps all job history data for any media to which an overwrite protection policy is currently assigned. After a media’s overwrite protection policy expires, the media’s job history data can be deleted.

Keep job history for specified number of days

Indicates the number of days to keep job history data in the database before it is deleted. Job history data includes summary statistics for a job and details about media, devices, and backup sets that were used to process the job.

Job logs

Indicates the number of days to keep job logs in the database before they are deleted. Job logs include detailed information about the job.

Alert history

Indicates the number of days to keep alert history data in the database before it is deleted. Alert history data includes property and response information for the alert.

Reports

Indicates the number of days to keep report data in the database before it is deleted. Report data includes property information about report jobs that were generated. The report itself is not deleted.

Audit logs

Indicates the number of days to keep audit log data in the database before it is deleted. The audit log includes information about operations that are performed in Backup Exec.

See About audit logs.

Perform database consistency check

Checks the logical and physical consistency of the data in the database.

The option is not checked by default. It is recommended that you run a consistency check periodically at a time when there is minimal activity from Backup Exec.

Save contents of database to the Backup Exec data directory

Places the data that is contained in the database into the Backup Exec data directory so that the database backup file (BEDB.bak) can be backed up. The dump file will be maintained in the data directory until the next database maintenance process is performed and then this file will be overwritten. Selecting this option enables you to recover the database in the event of failure.

Optimize database size

Reorganizes fragmented pages and decrease the size of the physical database to 10 percent above what is actually used.

Application settings for database maintenance