Microsoft KB Archive/298810

= PRB: Deleting the Last Destination Removes Log Shipping Completely =

Article ID: 298810

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Enterprise Edition

-



This article was previously published under Q298810



SYMPTOMS
If log shipping is set up with only one destination server, clicking the Delete button on the Log Shipping tab of the Maintenance Plan properties has the same effect as clicking the Remove Log Shipping button; it removes the log shipping pair completely.

To add another destination server after clicking either of these buttons, you will need to set up log shipping again using the Database Maintenance Wizard.



WORKAROUND
To add a destination to a log shipping pair while maintaining the present setup, add the new destination first and then delete the original secondary. This retains the present primary and monitor server setup and information.



MORE INFORMATION
This behavior is by design.

Keywords: kbprb KB298810

-

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

© Microsoft Corporation. All rights reserved.