Microsoft KB Archive/278897

= BUG: Existing Maintenance Plan Fails to Download to New Target Server =

Article ID: 278897

Article Last Modified on 10/17/2003

-

APPLIES TO


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

-



This article was previously published under Q278897



BUG #: 57873 (SQLBUG_70)

BUG #: 351334 (SHILOH)



SYMPTOMS
After you enlist a target server and add the new target server to an existing maintenance plan, the plan fails to download to the new target server.

NOTE: This problem occurs only when you add a new target server to an existing plan.



WORKAROUND
To work around this problem, edit the multiserver job &quot;Change on Target Servers Plan DB Maintenance Plan1&quot; to include the new target server as follows:
 * 1) In the SQL Enterprise Manager (SEM), under Management, click SQL Server Agent, click Jobs, and then click Multi Server Jobs. Right-click the appropriate &quot;Change on Target Servers Plan&quot; job, and then click Properties.
 * 2) On the General tab, click Change.
 * 3) Add the new target server to the list of selected target servers.
 * 4) Add a new schedule to the job, or start the job manually, so that the plan is downloaded to the new target server.

When you run this &quot;updated&quot; job, the plan is now available in the new target server.



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

Additional query words: MSX TSX master target enlist multi server maintenance plan

Keywords: kbbug kbpending KB278897

-

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

© Microsoft Corporation. All rights reserved.