Export (0) Print
Expand All

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.


object
.RetainDays [= value]

object

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

value

A long integer that specifies a number of days

Long

Read/write

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft