Online Documentation for SQL Manager for SQL server

Setting media options


This step is only available if the RadioButton Append to media option was selected on the Setting backup type and options step of the wizard.

 

At this step you can specify whether the application should check the name and password combination for the media. To enable this feature, check the corresponding option and enter a name and a password for the media.

 

Backup Database - Setting media options

 

 

The following step is only available if the RadioButton Overwrite media option is selected on the Setting backup type and options step of the wizard.

 

At this step you can set a number of options pertaining to the media being overwritten.

 

Backup Database - Setting Overwrite media options

 

 

CheckBox Format media

Specifies that the media header should be written on all volumes used for this backup operation. Any existing media header is overwritten. This option invalidates the entire media contents, ignoring any existing content.

NB: Use this option carefully. Formatting one backup device or medium renders the entire media set unusable. For example, if a single tape belonging to an existing striped media set is initialized, the entire media set is rendered useless.

 

CheckBox Don't backup to existing media if...

If the option is selected, the media will be first examined for any existing unexpired backup sets and for the correctness of the password. If the password is incorrect or the media contains any unexpired backup sets, the current media will not be used for backup.

 

Media name

Enter the name of the media.

 

Media password

Enter the password for the media.

 

Re-enter password

Repeat the password to avoid misprints.

 

Media description

Supply any optional text to describe the media.

 

Backup set expiration date

Define expiration date for the current backup set.

 

 

Click the Next button to proceed to the Setting advanced backup options step of the wizard.