Export (0) Print
Expand All
Expand Minimize

<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.

See Also
Defining the <Vacuum> Node
Show:
© 2014 Microsoft