Get-VESQLRestoreSession

In this article

    Short Description

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

    Applies to Veeam Backup & Replication

    Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License

    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

    Get-VESQLRestoreSessionExample 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

    Get-VESQLRestoreSessionExample 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.