Transact-SQL Reference

sp_delete_maintenance_plan_db

Disassociates the specified maintenance plan from the specified database.

Syntax

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

Arguments

[@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)

Remarks

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.

Permissions

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

Examples

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'