Show TOC

Scheduling Database and Transaction Log Backups (Windows)Locate this document in the navigation structure

Use

You can use the DBA Planning calendar to schedule

  • Full database backups of the master, msdb and SAP database
  • Differential database backups of the msdb and SAP database
  • Full, or differential database backups of other user databases created in SQL Server
  • Transaction log backups of these databases
    Note
    • You can backup the databases individually or together in the same action.
    • You schedule the backups as a recurring job with recurrence tab strip.

Procedure

To schedule the backups of the databases and the transactions logs, set the following parameters:

  • Database selection

    Select the databases for backup. You can select one, or any combination of the databases to backup.

  • Device selection

    Select the devices where the backup is written to. Generally, the default device R3DUMP0 is the correct entry here. For parallel backups, you can only choose one device type, either disk or tape devices.

  • Backup options
    • Unload Tape

      The tape is automatically unloaded

    • Initialize tape

      The existing contents of the tape are overwritten

    • Verify backup

      Ensures that all files that have just been written are readable. Always select this option.

    • Format tape

      Formats the tape so that the existing contents and header is deleted.

    • Expiration Period

      Accept the default value of 27 days, if you are performing the backup in the framework of the overall strategy recommended by SAP. Otherwise enter a different value.

    • Checksum

      Before writing the page to the backup media, BACKUP verifies the page for checksum or torn page, if this information is present on the page.

    • Compression

      Enables the backup compression. This option is only valid when the format option is selected as a new Media set will only be created during the format. Note that compressed and uncompressed backups cannot coexist in the same Media set.

You can also schedule the recurring job using the various options in the recurring tabs. When the job is finished you can view the log in the program log in MS SQL Server systems.