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.
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!