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

# Get-VESQLRDSDatabaseRestore

## Short Description
Returns active restore jobs for backed-up Microsoft SQL Server databases running on Amazon RDS.

**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-VESQLRDSDatabaseRestore -JobId <Guid> [<CommonParameters>]
```
  </li>
  <li>
    <p><code>AllParameterSet</code></p>

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

## Detailed Description
This cmdlet returns information about active restore jobs for a backed-up Microsoft SQL Server database running on Amazon RDS. You can stop the restore process with the [`Stop-VESQLRDSDatabaseRestore`](stop-vesqlrdsdatabaserestore.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 [`VESQLRDSDatabaseRestore`](vesqlrdsdatabaserestore.md)`[]` array that contains information about the restore process of backed-up Microsoft SQL Server databases running on Amazon RDS.

## Examples

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

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

```
$restore = Get-VESQLRDSDatabaseRestore
```

:::

::: 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-VESQLRDSDatabaseRestore -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-VESQLRDSDatabaseRestore -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-VESQLRDSDatabaseRestore -DatabaseName "db*"
```

:::