February 22, 2007 at 9:03 am
After you upgrade to SP2 (9.0.3042)
For Maintenance Plans that have the "Maintenance Cleanup Task" prior to SP2. You must go back and change the drop down list box under "delete files older then the following:" as it will be defaulted back to the top option which is "Hours".
I had this issue where ALL of my maintenance plans across multiple servers had this value reset from Days to Hours. This really isn't a big deal unless your doing all of your user databases backups in one maintenance plan and it takes longer then 1 hour to back them up or you have a very large database that takes longer then 1 hour to backup.
February 23, 2007 at 12:19 pm
Yep, I found this as well. It IS a big deal if you have backups from previous days and after the next backup of the db all of your past days backups are deleted.....
February 23, 2007 at 12:35 pm
Thanks. Forwarded it to other DBAs
Regards,Yelena Varsha
February 27, 2007 at 4:37 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply