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
Expand Minimize


SQL Server 2000

Disassociates the specified maintenance plan from the specified database.


sp_delete_maintenance_plan_db [ @plan_id = ] 'plan_id' ,
    [ @db_name = ] 'database_name'


[@plan_id =] 'plan_id'

Specifies the maintenance plan ID. plan_id is uniqueidentifier.

[@db_name =] 'database_name'

Specifies the database name to be deleted from the maintenance plan. database_name is sysname.

Return Code Values

0 (success) or 1 (failure)


sp_delete_maintenance_plan_db must be run from the msdb database.

The sp_delete_maintenance_plan_db stored procedure removes the association between the maintenance plan and the specified database; it does not drop or destroy the database.

When sp_delete_maintenance_plan_db removes the last database from the maintenance plan, the stored procedure also deletes the maintenance plan.


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


Deletes the Northwind database, previously added with sp_add_maintenance_plan_db.

EXECUTE   sp_delete_maintenance_plan_db N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC', N'Northwind'
© 2015 Microsoft