Aracılığıyla paylaş


BackupRestoreBase.MaxTransferSize Property

Gets or sets the maximum number of bytes to be transferred between the backup media and the instance of SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)

Syntax

'Bildirim
Public Property MaxTransferSize As Integer
    Get
    Set
'Kullanım
Dim instance As BackupRestoreBase
Dim value As Integer

value = instance.MaxTransferSize

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

Property Value

Type: System.Int32
An Int32 value that specifies the maximum number of bytes to be transferred in the backup and restore operation.

Remarks

The possible values are multiples of 65536 bytes (64 KB), up to 4194304 bytes (4 MB).

Examples

Backing Up and Restoring Databases and Transaction Logs

See Also

Reference

BackupRestoreBase Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

RESTORE (Transact-SQL)

BACKUP (Transact-SQL)