Tags

–Execute on SOURCE
EXEC master.dbo.sp_delete_log_shipping_primary_secondary
@primary_database = N’DatabaseName’ ,
@secondary_server = N’SQLSERVER\INSTANCE’ ,
@secondary_database = N’DatabaseName’

–Execute on SOURCE
EXEC master.dbo.sp_delete_log_shipping_primary_database @database = N’DatabaseName’
***If you have more than 1 log shipping destination, be aware of using sp_delete_log_shipping_primary_database because this will effect all of the other destinations.

–Execute on Target
EXEC master.dbo.sp_delete_log_shipping_secondary_database
@secondary_database = N’DatabaseName’

http://sqlserverpedia.com/wiki/Removing_Log_Shipping_%28SQL_Server_2005%29

Advertisements