195 pts.
 Build 09.00.3239.00 (cumulative update)
I just patched my servers to this build and noticed that the time used to 'Delete files based on the age of the file at task run time' within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed this with this build?

Software/Hardware used:
ASKED: April 25, 2008  5:53 PM
UPDATED: April 25, 2008  8:57 PM

Answer Wiki:
This is a known issue which was introduced in SQL Server 2005 SP2. After installing SP 2 or later for the first time you need to edit your maintenance plans and change the deletion interval. This is because Microsoft added in an additional option for how long to keep the files.
Last Wiki Answer Submitted:  April 25, 2008  8:57 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,520 pts.