How to remove log shipping (Enterprise Manager)
SQL Server 2000
To remove log shipping
- Expand a server group, and then expand the primary server.
- Expand Management, and then click Database Maintenance Plans.
- In the details pane, right-click the database maintenance plan to delete, and then click Properties.
- Click the Log Shipping tab, and then click Remove Log Shipping.
This stops log shipping on the primary server, removes all secondary servers, and removes the monitor server. You must delete the database maintenance plan to remove additional jobs.