Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


SQL Server 2000

Deletes a log shipping plan.


sp_delete_log_shipping_plan [ @plan_id = ] plan_id |
    [ @plan_name = ] 'plan_name'
    [ , [ @del_plan_db = ] del_plan_db ]


[@plan_id =] plan_id

Is the identification number of the plan to delete. plan_id is uniqueidentifier, with a default of NULL.

[@plan_name =] 'plan_name'

Is the name of the plan to delete. plan_name is sysname, with a default of NULL.

Note  Either plan_id or plan_name must be specified; both cannot be specified.

[@del_plan_db =] del_plan_db

Specifies that all rows from log_shipping_databases table that belong to this plan will be deleted. del_plan_db is bit, with a default of 0.

Return Code Values

0 (success) or 1 (failure)


If there are corresponding rows in the log_shipping_databases table, then del_plan_db must be set to one (1) or the stored procedure will fail.


Only members of the sysadmin fixed server role can execute sp_delete_log_shipping_plan.


This example deletes the plan "Pubs database backup" and any databases added to the plan.

EXEC   msdb.dbo.sp_delete_log_shipping_plan @plan_name = N'Pubs database backup', @del_plan_db = 1
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft