Loading...

Creating an Automatic Schedule for Database Log Backups

Applies to: Microsoft SQL Server, Oracle, Oracle RAC, SAP for Oracle, Notes Database traditional log backups

Create an automatic schedule to automatically run a database log backup when specific criteria are met, for example, run a backup when the archive log destination fills up to a specified capacity.

Automatic backups of database log files use the data protection resources more efficiently because they only run backup jobs when there is enough data to back up. A non-automatic schedule runs the backup at the specified date and time, even if there is not enough data to back up.

Take the following into consideration when plan your log backup schedule:

  • The number of transactions that the database generates
  • The disk size for the log file destination

About This Task

The Minimum Interval Between Jobs parameter ensures that the software does not frequently run the job. The software does not check the database threshold options during this interval.

The Maximum Interval Between Jobs parameter ensures that the software backs up the logs even when the database threshold options have not been met. For example, if the parameter is set to 24 hours and the software has not run an automatic log backup in that time, the software will start a backup without checking the database options.

If you assign this schedule type to a subclient that has no backups prior to the assignment, the first backup runs irrespective of the database threshold options.

Use the information in the table to determine the parameter values.

Agents Notes
Microsoft SQL Server
  • Set a low minimum interval to set frequency of check for log space for each database. For example, set a minimum interval of 10 minutes.
  • Depending on your environment, set an optimal log percent which should trigger transaction log backup and truncation. Default value is 80%.
Oracle Best Practice: Back up the logs before the archive log destination fills up to 80% of the space (Backup Task Options dialog box, Schedule Pattern tab, Start backup when disk at log destination is box).
Oracle RAC Best Practice: Back up the logs before the archive log destination fills up to 80% of the space (Backup Task Options dialog box, Schedule Pattern tab, Start backup when disk at log destination is box).
SAP for Oracle If you use automatic schedules for log backups, they run as full backups.

Best Practice: Back up the logs before the archive log destination fills up to 80% of the space (Backup Task Options dialog box, Schedule Pattern tab, Start backup when disk at log destination is box).

Notes Database The Maximum Interval between Jobs option must be more than 15 minutes.

You can also configure a schedule policy for automatic database log backups. For information on how to configure a schedule policy, see Creating a Schedule Policy for Automatic Database Log Backups.

Procedure

  1. From the CommCell Browser, expand Client Computers > client > agent > instance.
  2. Right-click the subclient configured for the archive log backup and then click Backup.
  3. On the Backup Options for Subclient dialog box, select Schedule and then click Configure.

    The Schedule Details dialog box is displayed.

  4. In the Schedule Name box, enter a unique name for the schedule.
  5. Select Automatic.
  6. In the Minimum Interval Between Jobs box, enter the minimum time to start the job.

    Note: If this value is met, the job starts regardless of whether the database criteria are met.

  7. In the Maximum Interval Between Jobs box, enter the maximum time to start the job.

    Note: If this value is met, the job starts regardless of whether the database criteria are met.

  8. Select the criteria to use to run backup jobs:
    Database Option
    Oracle

    Oracle RAC

    SAP for Oracle

    Notes

    To run backup jobs when the number of log files on the disk use a specified amount of the storage space, select the Start backup when disk at log destination is option.

    To run backup jobs when the number of log files on the disk reach a specified number, select the Number of Archived Logs in Destination option.

    SQL To run backup jobs when the used space of log file reached specified percentage, select the Start backup when the log file is option.
  9. Click OK to close the Schedule Details dialog box.