SQL Server Backup (Options Tab)
Use this tab to view or specify the following options.
Options
Verify backup upon completion
Specify that the media integrity of the backup is verified upon completion.
Eject tape after backup
Eject the backup media tape after the backup is complete.
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 will expire
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.
Initialize and label media
Write the Microsoft Tape Format (MTF) header to the beginning of the media. This will erase all contents and any previous media header information. The backup set expiration and media set name are not checked when initializing a media.
Media set name
Write the media name to the media as part of the MTF header.
Media set description
Write the media description to the media as part of the MTF header. This is typically what the media is used for or where it is stored.