SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

Restore.FileNumber Property

SQL Server 2012

Gets or sets the index number used to identify the targeted backup set on the backup medium.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.SmoExtended (in Microsoft.SqlServer.SmoExtended.dll)
C#
C++
F#
JScript
VB
Copy 
public int FileNumber { get; set; }

Property Value

Type: System.Int32
An Int32 value that specifies the backup set index number.

The following code example demonstrates how to set the index number of the backup associated with the restore instance to 1.

VB

Copy 
Dim rs As Restore
rs = New Restore
rs.FileNumber = 1

PowerShell

Copy 
$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.FileNumber = 1
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.