BUG: DB Maintenance Plan Cannot Be Modified to Include/Exclude Integrity Checks Before Backups (264194)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q264194
BUG #: 57821 (SQLBUG_70)
BUG #: 353586 (SHILOH_BUG)

SYMPTOMS

After the initial creation, a database maintenance plan cannot be modified to include or exclude integrity checks to be performed before backing up the database or transaction log.

WORKAROUND

Re-create the database maintenance plan with the necessary options.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.
Microsoft has confirmed this to be a problem in SQL Server 2000.

MORE INFORMATION

To reproduce the problem, follow these steps:
  1. Create a database maintenance plan, with or without selecting the Check database integrity option. Do not select Perform these tests before doing backups.
  2. Browse to the Database Maintenance Plans folder under Management and try to modify the plan. Double-click the plan, click the Integrity tab, and select Perform these tests before backing up the database or transaction log. (If you did not select Check database integrity in step 1, select it first to enable the Perform these tests before backing up the database or transaction log option.) Click Apply and then click OK.
  3. Double-click the plan again, and you will see that the changes made were not saved.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbbug kbpending KB264194
©2003 Microsoft Corporation. All rights reserved.