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