This topic has not yet been rated - Rate this topic

Restore.Offset Property

SQL Server 2012

SQL Server 2005

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

C++

JScript

public long[] Offset { get; set; }

Property Value

Type: 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.

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

Reference

Restore Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

RESTORE (Transact-SQL)

Back Up and Restore of SQL Server Databases

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD