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

'Declaration
Public Property MaxTransferSize As Integer 
    Get 
    Set
'Usage
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)