Removing Log Shipping
You can remove log shipping from a primary database by disabling it in SQL Server Management Studio or by using the log shipping Transact-SQL stored procedures. When you remove log shipping from a database, all log shipping related jobs and schedules will be removed, along with log shipping history and error information. The databases themselves on both the primary and secondary servers will not be changed.
If you are planning to delete a database that is part of a log shipping configuration, remove log shipping first.
For information about removing log shipping using Management Studio, see How to: Remove Log Shipping (SQL Server Management Studio).
For information about removing log shipping using Transact-SQL, see How to: Remove Log Shipping (Transact-SQL).
For information about removing previous versions of log shipping, see Migrating a SQL Server 2000 Log Shipping Configuration to SQL Server 2008.