<RetentionAge> Element
SQL Server 2000
Specifies the minimum age at which system data is considered to be obsolete and available for removal.
Structure
<ApplicationExecutionSettings>
...
<Vacuum>
<RetentionAge>
Element Characteristics
| Characteristic | Description |
|---|---|
| Data Type | duration. |
| Default Value | Seven days. |
| Occurrence | Optional once per <Vacuum> node. |
| Updates | Can be modified, but not added or deleted, using NSControl Update. |
Element Relationships
| Relationship | Elements |
|---|---|
| Parent Node | <Vacuum> Node |
Remarks
Data is not removed any earlier than the period specified by the <RetentionAge> element, although it is not necessarily removed immediately on expiration of the specified period.
The format of the XML duration data type is P0DT00H00M00S. For more information about XML data types, see Primitive XML Data Types in the Microsoft MSDN® Library.