Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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