Deleting a maintenance plan

Using SQL 7, going into EM, and clicking on one of the databases, I see two
maintenance plans listed. One of them is active, and the other has no
options checked and nothing schueduled. How can I delete the unused
maintenance plan? Thanks!

Neil


.

Relevant Pages

  • Re: SQL 2000 - Databases getting backed up multiple times
    ... I called ARCServe and they agreed that we don't need both the native SQL ... Maintenance Plans backing up our logs and databases in addition to ARCServe. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging details in SQL Server 2005 Maintenance Plan
    ... Andrew J. Kelly SQL MVP ... Does not occur when you run the Maint Plan vanilla ... >> In setting up maintenance plans in SQL 2005, I am unable to get the ... >> log file? ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL 2005 deleting old backups
    ... There were several issues with the maintenance plans and SP2. ... Loading SP2 was not enough, you need to load some hotfixes etc to fix all the crap that SP2 broke. ... A client of ours has SQL Server 2005 with the latest service pack. ... the subplans in the database maintenance plans is to delete old backup files ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2000 Maintenance Plan Email Notifications
    ... Andrew J. Kelly SQL MVP ... > client open, frequently locks up, won't work in a clustered environment, ... > notifications can break if you start editing your maintenance plans. ...
    (microsoft.public.sqlserver.setup)
  • Re: Maintenance PLan recommendation
    ... I use maintenance plans ONLY for transaction log backups. ... all other tasks I write SQL scripts and schedule them manually. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)