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

Get-VESQLRestoreSession

Short Description

Returns active restore sessions started to perform operations with backed-up Microsoft SQL databases.

Applies to Veeam Backup & Replication

Product Edition: Community, Standard, Enterprise, Enterprise Plus

Syntax

Get-VESQLRestoreSession  [<CommonParameters>]

Detailed Description

This cmdlet returns an array of active restore sessions started to perform operations with backed-up Microsoft SQL databases.

Get-VESQLRestoreSession Note:

The cmdlet returns restore sessions initiated in the PowerShell console only. The cmdlet does not return restore sessions running in the Veeam Backup & Replication console.

<CommonParameters>

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

Output Object

The cmdlet returns the VESQLRestoreSession object that contains settings of restore sessions started to explore backed-up Microsoft SQL databases and to perform operations with these databases.

Examples

Example 1. Getting all Running Restore Sessions

This command gets all running restore sessions to perform operations with Microsoft SQL databases. Save the result to the $session variable to be able to use it with other cmdlets.

$session = Get-VESQLRestoreSession

Example 2. Getting Specific Restore Session

This example shows how to get a specific restore session to perform operations with Microsoft SQL databases.

$session = Get-VESQLRestoreSession

$session[3]

Perform the following steps:

  1. Run the Get-VESQLRestoreSession cmdlet. Save the result to the $session variable.

The Get-VESQLRestoreSession cmdlet will return an array of active restore sessions. Mind the ordinal number of the necessary restore session (in our example, it is the fourth restore session in the array).

  1. Specify the necessary ordinal number of the restore session for the $session variable. In our example, it is the fourth restore session in the array.