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

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 will be written to. Generally the default device R3DUMP0 is the correct entry here. For parallel backups, you can only choose one devices 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.

You can also schedule the job recurring using the various options in the recurring taps. After the job is finished you can view the log using the program log in MS SQL server systems.