<RetentionAge> Element
Collapse the table of content
Expand the table of content

<RetentionAge> Element

SQL Server 2000

Specifies the minimum age at which system data is considered to be obsolete and available for removal.


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

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
© 2016 Microsoft