Microsoft KB Archive/264194

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

Article ID: 264194

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



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.

Additional query words: sqlmaint

Keywords: kbbug kbpending KB264194

-

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

© Microsoft Corporation. All rights reserved.