Export (0) Print
Expand All
Expand Minimize

Vacuum Element (ADF)

SQL Server 2005

Contains settings used by the data removal process, which removes obsolete event and notification data from the application database.


<ApplicationExecutionSettings>
    ...
    <Vacuum>

Characteristic Description

Data type

None.

Default value

None.

Occurrence

Optional once per ApplicationExecutionSettings element.

Updates

Can be added and deleted when updating the application.

Vacuuming removes obsolete event and notification data from the application database. For more information about the vacuuming process, see Removing Obsolete Application Data.

Vacuuming schedules cannot overlap. If schedules overlap, Notification Services stops the earlier vacuuming process before the later one starts.

If you omit the Vacuum element and its child elements, the vacuuming process does not run and obsolete data is not automatically removed from the application database.

The following example shows how to define a data retention age of three days (P3DT00H00M00S) and to configure the vacuuming process to run from 3:00 A.M. to 5:00 A.M. (UTC) and from 11:00 P.M. to 1:00 A.M. (UTC) every day.

<Vacuum>
    <RetentionAge>P3DT00H00M00S</RetentionAge>
    <VacuumSchedule>
        <Schedule>
            <StartTime>23:00:00</StartTime>
            <Duration>P0DT02H00M00S</Duration>
        </Schedule>
        <Schedule>
            <StartTime>03:00:00</StartTime>
            <Duration>P0DT02H00M00S</Duration>
        </Schedule>
    </VacuumSchedule>
</Vacuum>

Community Additions

ADD
Show:
© 2015 Microsoft