PRB: Backup Wizard May Not Display the "Verify Backup" Option Correctly (271171)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q271171

SYMPTOMS

The Backup Wizard in SQL Server Enterprise Manager may not display the Verify Backup option as expected. If you select the After completing the backup, read and verify the integrity of the backup option when you use the Backup Wizard, the final summary screen Completing the Create Backup Wizard may report the following:
"Verify backup: NO".
This text may appear when you select the Initialize and Label Media option in the Initialize Media dialog box of the Backup Wizard. The Initialize Media option is available when overwriting of backup media will be done. This is only a display issue and does not affect the actual process of verifying the backup.

CAUSE

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

  1. From the Tools menu, click Wizards. In the Select Wizard dialog box click the Management tab, and then click Backup Wizard.
  2. Complete the following steps in the Select Backup Destination and Action dialog box:
    1. Select the Overwrite backup media check box.
    2. Select the After completing the backup, read and verify the integrity of the backup check box.
    3. Click Next.
  3. In the Initialize Media dialog box:
    1. Select the Initialize and label media check box.
    2. Click Next.
Now, the Completing the Create Backup Wizard dialog box should list all the options that you selected. Instead, you see: 
   Verify Backup: No
The option that is shown is incorrect. The text that displays was selected in the Select Backup Destination and Action dialog box, as an option.

The Verify Backup option is overwritten, when you select the Overwrite backup media option in the Select Backup Destination and Action dialog box.

This behavior has been changed in SQL Server 2000, and the Verify Backup option now specifies whether or not it was selected.
Modification Type:MajorLast Reviewed:10/23/2000
Keywords:kbprb KB271171
©2002 Microsoft Corporation. All rights reserved.