---
title: "Get-VESQLDatabaseRestore"
description: "Returns active restore jobs for Microsoft SQL Server databases. Product: Veeam Backup & Replication Product Edition: Enterprise Plus, Veeam Universal License This cmdlet provides the following parameter sets: This cmdlet returns information about"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vesqldatabaserestore.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > Get-VESQLDatabaseRestore"
dateModified: "2026-08-18"
---

# Get-VESQLDatabaseRestore

## Short Description
Returns active restore jobs for Microsoft SQL Server databases.

**Product**: Veeam Backup & Replication

**Product Edition**: Enterprise Plus, Veeam Universal License

## Syntax

This cmdlet provides the following parameter sets:

<ul class="syntax-sets">
  <li>
    <p><code>ByIdParameterSet</code></p>

```
Get-VESQLDatabaseRestore -JobId <Guid> [<CommonParameters>]
```
  </li>
  <li>
    <p><code>AllParameterSet</code></p>

```
Get-VESQLDatabaseRestore [-DatabaseName <String[]>] [<CommonParameters>]
```
  </li>
</ul>

## Detailed Description
This cmdlet returns information about active restore jobs for a Microsoft SQL Server database. You can stop the restore process with the [`Stop-VESQLDatabaseRestore`](stop-vesqldatabaserestore.md) cmdlet.

Note the difference between a restore session and a restore job. A restore session is a preliminary step where Veeam Explorer for Microsoft SQL Server has retrieved the backup from the backup repository, pending restore operations. A restore job is the process of restoring data from the backup to the target Microsoft SQL Server machine.

## Parameters

<table style="width:100%;" class="Blue_Table">
      <tr style="vertical-align:top">
        <th style="width:20%;">
          <p>Parameter</p>
        </th>
        <th style="width:20%;">
          <p>Description</p>
        </th>
        <th style="width:20%;">
          <p>Type</p>
        </th>
        <th style="width:10%;">
          <p>Required</p>
        </th>
        <th style="width:10%;">
          <p>Position</p>
        </th>
        <th style="width:10%;">
          <p>Accept Pipeline Input</p>
        </th>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">DatabaseName</span></p>
        </td>
        <td>
          <p>Specifies names of restored Microsoft SQL Server databases. The cmdlet will return restore jobs performed for the specified databases.</p><p>This parameter accepts wildcard characters.</p>
        </td>
        <td style="width:10%;">
          <p><code>String[]</code></p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>False</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">JobId</span></p>
        </td>
        <td>
          <p>Specifies the job ID of the required restore job. The cmdlet will return information about the specified restore job.</p>
        </td>
        <td style="width:10%;">
          <p><code>Guid</code></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>Named</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</p>
        </td>
      </tr>
    </table>

`<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 [`VESQLDatabaseRestore`](vesqldatabaserestore.md)`[]` array that contains details on the restore job for a Microsoft SQL Server database.

## Examples

::: example
### Example 1. Getting All Restore Processes

This command returns a list of all active restore processes for Microsoft SQL Server databases. Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VESQLDatabaseRestore
```

:::

::: example
### Example 2. Getting Restore Process by Job ID

This example shows how to get a specific restore job by its job ID. Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VESQLDatabaseRestore -JobId "b6b9b806-bc7c-491c-8ef7-0490d0d2608c"
```

:::

::: example
### Example 3. Getting Restore Processes for Specific Database

This command returns all active restore processes for a specific database. Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VESQLDatabaseRestore -DatabaseName "location1"
```

:::

::: example
### Example 4. Getting Restore Processes for Specific Databases Using Wildcards

This command returns all active restore jobs for databases whose names begin with "db". Save the result to the `$restore` variable to be able to use it with other cmdlets.

```
$restore = Get-VESQLDatabaseRestore -DatabaseName "db*"
```

:::