This is an archive version of the document. To get the most up-to-date information, see the current version.

Get-VESQLDatabaseFile

Short Description

Returns full file names for backed-up Microsoft SQL databases.

Applies to Veeam Backup & Replication

Product Edition: Community, Standard, Enterprise, Enterprise Plus

Syntax

Get-VESQLDatabaseFile [-Database] <VESQLDatabase>  [<CommonParameters>]

Detailed Description

This cmdlet returns an array of full file names for backed-up Microsoft SQL databases.

Parameters

Parameter

Description

Type

Required

Position

Accept Pipeline Input

Accept Wildcard Characters

Database

Specifies a Microsoft SQL database. The cmdlet will return an array of full file names for the specified database.

Accepts the VESQLDatabase type. To get this object, run the Get-VESQLDatabase cmdlet.

True

0

True (ByValue)

False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Docs.

Return Type

The cmdlet returns the VESQLDatabaseFile[] object that contains an array of full file names for backed-up Microsoft SQL databases.

Examples

Getting List of Full File Names for Backed-Up Microsoft SQL Database

This example shows how to get a list of full file names for a backed-up Microsoft SQL database.

$session = Get-VESQLRestoreSession

$database = Get-VESQLDatabase -Session $session[1]

Get-VESQLDatabaseFile -Database $database

Perform the following steps:

  1. Run the Get-VESQLRestoreSession cmdlet. Save the result to the $session variable.
  2. Run the Get-VESQLDatabase cmdlet. Set the $session variable as the Session parameter value. Save the result to the $database variable.
  3. Run the Get-VESQLDatabaseFile cmdlet. Set the $database variable as the Database parameter value.

Related Commands