Restore::Offset Property

 

Gets or sets the array of page addresses to be restored.

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

public:
property array<long long>^ Offset {
	array<long long>^ get();
	void set(array<long long>^ value);
}

Property Value

Type: array<System::Int64>^

An Int64 array value that specifies the page addresses of the pages to be restored.

The following code example demonstrates how to specify the page addresses to be saved during a restore operation.

VB

Dim rs As Restore
rs = New Restore
rs.Action = RestoreActionType.OnlinePage
Dim a() As Integer = {4,5,6}
rs.Offset = a

PowerShell

$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.Action = [Microsoft.SqlServer.Management.Smo.RestoreActionType]::OnlinePage
$a = @(4, 5, 6)
$rs.Offset = $a
Return to top
Show: