Backup.LogTruncation Propiedad

Gets or sets the method used to truncate the database log as part of the backup operation.

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

Sintaxis

'Declaración
Public Property LogTruncation As BackupTruncateLogType 
    Get 
    Set
'Uso
Dim instance As Backup 
Dim value As BackupTruncateLogType 

value = instance.LogTruncation

instance.LogTruncation = value

public BackupTruncateLogType LogTruncation { get; set; }

public:
property BackupTruncateLogType LogTruncation {
    BackupTruncateLogType get ();
    void set (BackupTruncateLogType value);
}

member LogTruncation : BackupTruncateLogType with get, set

function get LogTruncation () : BackupTruncateLogType 
function set LogTruncation (value : BackupTruncateLogType)

Valor de la propiedad

Tipo: Microsoft.SqlServer.Management.Smo.BackupTruncateLogType
A BackupTruncateLogType object value that specifies the log truncation option that has been selected. By default, the value is set to Truncate.

Comentarios

You can use the BackupTruncateLogType object to select one of the following log truncation options:

• Truncate only. The log is truncated and is not backed up.

• No truncate. The log is backed up and is not truncated.

• Truncate (default). The log is backed up, and is then truncated.

Ejemplos

VB

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

PowerShell

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

Vea también

Referencia

Backup Clase

Espacio de nombres Microsoft.SqlServer.Management.Smo

Otros recursos

BACKUP (Transact-SQL)

Realizar de copias de seguridad y restaurar bases de datos y registros de transacciones