Thursday, March 22, 2012

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

No comments:

Post a Comment