Compartir a través de


RetainDays Propiedad

Gets or sets the number of days that must elapse before a backup set can be overwritten.

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.SmoExtended (en Microsoft.SqlServer.SmoExtended.dll)

Sintaxis

'Declaración
Public Property RetainDays As Integer
    Get
    Set
'Uso
Dim instance As Backup
Dim value As Integer

value = instance.RetainDays

instance.RetainDays = value
public int RetainDays { get; set; }
public:
property int RetainDays {
    int get ();
    void set (int value);
}
member RetainDays : int with get, set
function get RetainDays () : int
function set RetainDays (value : int)

Valor de la propiedad

Tipo: System. . :: . .Int32
An Int32 value that specifies the retention period in days. By default, the value is set to zero.

Comentarios

Backup set retention period is set when media is initialized. When using SQL Server Management Objects (SMO) to automate Microsoft SQL Server backup, the RetainDays property is only evaluated when the Initialize property is True.

Ejemplos

VB

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Reference the AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
Dim bk As New Backup
bk.Action = BackupActionType.Database
bk.Database = "AdventureWorks2008R2"
bk.RetainDays = 21

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")
$db = New-Object Microsoft.SqlServer.Management.Smo.Database
$db = $srv.Databases.Item("AdventureWorks2008R2")
$bk = new-object Microsoft.SqlServer.Management.Smo.Backup
$bk.Action = [Microsoft.SqlServer.Management.Smo.BackupActionType]::Database
$bk.Database = "AdventureWorks2008R2"
$bk.RetainDays = 21