• Article

RetainDays Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The RetainDays property specifies the number of days that must elapse before a backup set can be overwritten.

Syntax

object
.RetainDays [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A long integer that specifies a number of days

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetRetainDays(LPLONG pRetVal);
HRESULT SetRetainDays(long NewValue);

Remarks

For Microsoft SQL Server, backup set retention period is set when media is initialized. If SQL Distributed Management Objects (SQL-DMO) is used to automate SQL Server backup, the RetainDays property is only evaluated if the Initialize property is TRUE.

Applies To:

Backup Object