Microsoft KB Archive/271171

= PRB: Backup Wizard May Not Display the &quot;Verify Backup&quot; Option Correctly =

Article ID: 271171

Article Last Modified on 10/23/2000

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



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:

&quot;Verify backup: NO&quot;.

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.



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:
 * 3) Select the Overwrite backup media check box.
 * 4) Select the After completing the backup, read and verify the integrity of the backup check box.
 * 5) Click Next.
 * 6) In the Initialize Media dialog box:
 * 7) Select the Initialize and label media check box.
 * 8) 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.

Additional query words: Backup Wizard, Enterprise Manager, Verify

Keywords: kbprb KB271171

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.