Scheduling Database and Transaction Log Backups (Windows) 

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

●    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.