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)
Syntax
'Declaration
Public Property Offset As Long()
Get
Set
'Usage
Dim instance As Restore
Dim value As Long()
value = instance.Offset
instance.Offset = value
public long[] Offset { get; set; }
public:
property array<long long>^ Offset {
array<long long>^ get ();
void set (array<long long>^ value);
}
member Offset : int64[] with get, set
function get Offset () : long[]
function set Offset (value : long[])
Property Value
Type: array<System.Int64[]
An Int64 array value that specifies the page addresses of the pages to be restored.
Examples
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
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace