Restore.FileNumber Property

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)

Syntax

'Declaration
Public Property FileNumber As Integer 
    Get 
    Set
'Usage
Dim instance As Restore 
Dim value As Integer 

value = instance.FileNumber

instance.FileNumber = value
public int FileNumber { get; set; }
public:
property int FileNumber {
    int get ();
    void set (int value);
}
member FileNumber : int with get, set
function get FileNumber () : int 
function set FileNumber (value : int)

Property Value

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

Examples

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

VB

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

PowerShell

$rs = new-object Microsoft.SqlServer.Management.Smo.Restore
$rs.FileNumber = 1

See Also

Reference

Restore Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

RESTORE (Transact-SQL)

Back Up and Restore of SQL Server Databases