Delete Database Maintenance Plan

If I delete the database maintenance plan, will the jobs
(Like DB Backup Job) be deleted automatically ?
Thank you for your advice.Yes! Just try it out to confirm.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Roger Lee" <anonymous@.discussions.microsoft.com> wrote in message
news:055f01c39cfa$ce8b0440$a501280a@.phx.gbl...
> If I delete the database maintenance plan, will the jobs
> (Like DB Backup Job) be deleted automatically ?
> Thank you for your advice.

delete backup file

Hi,
I have a database which size is 64Go, and i backup it everyday with 1 day of retention.
But the maintenance plan don't delete the file older than 1 day.
This works fine for the other db.
Do you know what is the pb ?
regards.Hi,
I have a database which size is 64Go, and i backup it everyday with 1 day of retention.
But the maintenance plan don't delete the file older than 1 day.
This works fine for the other db.
Do you know what is the pb ?
regards.

Does the maintenance plan generate an error log? It should be in %Install Path%\MSSQL\LOGS. Look through there. As I recall, if there is any problem anywhere in the process of making the backup, the purge old files process will not work (this is by design).

Regards,

hmscott

delbkups not working for SQL 2000

Hello,

In our maintenance plan for SQL Server 2000, we are performing full backups which in turn has their retention setting to 2 days. Unfortunately, it appears that this option is not working. Has anybody else seen this? We are running on Windows 2000 Advanced Server.

-LIONSPARCHave you changes the path...have you looked in the job history, what about the error logs...

maybe try and disable it, and create a new one...

Never had a problem with it...|||We are thinking long the lines of...

Microsoft Knowledge Base Article - 278667
BUG: Sqlmaint Does Not Delete Expired Backup Files on Windows 95, 98 or ME Computers

But I will first try re-creating the maintenance plan.

-lionsparc|||WIN2k Advanced server?

I would highly doubt it...MS might as well fold there tent, hide the snake oil and close up the 3 card montee game now...

oooppps didn't mean that they don't make a decent product...|||We're LOL on that one. I will let you know how we make out. One thing that is interesting is that we "changed" the maintenance plan to remove files 2 days+ old. So the original didn't have it. However, we did check the job history and appears the -delbckups 2DAYS isn't showing anything in the log. We see "delete old text files" but that's it. Do you know how it should show in the history? Thanks!

-LIONSPARC|||I can't find any messaging indicating the delets...just the maint logs..nothing there...

As an alternative...you can create your own sprocs to take care of this...

And create any logging you want...very customizable...

good lucksql