Backup Database (Options Tab)

Use this tab to view or specify the following options.

Verify backup on completion
Specify that the media integrity of the backup is verified upon completion.

Remove inactive entries from transaction log
Remove from the transaction log all entries for completed transactions upon completion of the backup.

Check media set name and backup set expiration
Check the media set name and backup set expiration date before overwriting the media.

Media set name
Specify the media set name the media must have before they can be overwritten.

Backup set expiration
Set the backup set expiration conditions. Microsoft SQL Server only uses the backup expiration information from the first backup set on the media to determine whether the entire media can be overwritten.

After
Specify the number of days after the backup is completed before the media can be overwritten.

On
Specify the date on which the media can be overwritten.