---
title: "Get-VESQLRestoreSession"
description: "Returns active restore sessions started to perform operations with backed-up Microsoft SQL Server databases. Product: Veeam Backup & Replication Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdle"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vesqlrestoresession.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > Get-VESQLRestoreSession"
dateModified: "2026-08-18"
---

# Get-VESQLRestoreSession

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

**Product**: 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 for Microsoft SQL Server databases.

::: note

- You can only get an array of restore sessions that are started in PowerShell. The cmdlet does not return restore sessions started in the Veeam Backup & Replication console.
- The cmdlet only returns an array of restore sessions started within the same PowerShell session.

:::

## Parameters

`<CommonParameters>`

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the [About Common Parameters](http://go.microsoft.com/fwlink/p/?LinkID=113216) section of Microsoft Docs.

## Output Object
The cmdlet returns the [`VESQLRestoreSession`](vesqlrestoresession.md)`[]` array that contains settings of restore sessions started to explore backed-up Microsoft SQL Server databases and to perform operations with these databases.

## Examples

::: example
### Example 1. Getting all Running Restore Sessions

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

```
$session = Get-VESQLRestoreSession
```

:::

::: example
### Example 2. Getting Specific Restore Session

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

```
$session = Get-VESQLRestoreSession
$session[3]
```

Perform the following steps:

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

   The cmdlet will return an array of active restore sessions. Note the ordinal number of the necessary restore session (in this example, it is the fourth restore session in the array).

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

:::