Vacumming Question
We have SQL NS 2005 with our ADF with the following setting:
<Vacuum>
<RetentionAge>P7DT00H00M00S</RetentionAge>
<VacuumSchedule>
<Schedule>
<StartTime>05:00:00</StartTime>
<Duration>P0DT02H00M00S</Duration>
</Schedule>
</VacuumSchedule>
</Vacuum>
<RetentionAge>P7DT00H00M00S</RetentionAge>
<VacuumSchedule>
<Schedule>
<StartTime>05:00:00</StartTime>
<Duration>P0DT02H00M00S</Duration>
</Schedule>
</VacuumSchedule>
</Vacuum>
Shouldn't this only be retaining data for 7 days, which perhaps I should remove defined RetentionAge since that is supposed to be the default according to BOL.
We have rolled this out in November, but I am not seeing any old data getting cleaned up.
Is it my configuration setting or a bug? I have run exec nssnapshotapplications and it shows it is running on the scheduled basis. I just want to get some clarification before making a change for our production environment.
[982 byte] By [AndyWilbourn] at [2008-2-25] 