---
title: "Stop-VESQLRDSDatabaseRestore"
description: "Stops a restore job for a backed-up Microsoft SQL Server database running on Amazon RDS. Product: Veeam Backup & Replication Product Edition: Enterprise Plus, Veeam Universal License This cmdlet stops a restore job for a backed-up Microsoft SQL S"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/stop-vesqlrdsdatabaserestore.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > Stop-VESQLRDSDatabaseRestore"
dateModified: "2026-08-18"
---

# Stop-VESQLRDSDatabaseRestore

## Short Description
Stops a restore job for a backed-up Microsoft SQL Server database running on Amazon RDS.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Stop-VESQLRDSDatabaseRestore [-DatabaseRestore] <VESQLRDSDatabaseRestore> [-Force] [<CommonParameters>]
```

## Detailed Description
This cmdlet stops a restore job for a backed-up Microsoft SQL Server database running on Amazon RDS.

## 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">DatabaseRestore</span></p>
        </td>
        <td>
          <p>Specifies a restore job for a Microsoft SQL Server database.</p><p>Accepts the <a href="vesqlrdsdatabaserestore.md"><code>VESQLRDSDatabaseRestore</code></a> object. To get this object, run the <a href="get-vesqlrdsdatabaserestore.md"><code>Get-VESQLRDSDatabaseRestore</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vesqlrdsdatabaserestore.md"><code>VESQLRDSDatabaseRestore</code></a></p>
        </td>
        <td style="width:10%;">
          <p>True</p>
        </td>
        <td style="width:10%;">
          <p>0</p>
        </td>
        <td style="width:10%;">
          <p>True (ByValue)</p>
        </td>
      </tr>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Force</span></p>
        </td>
        <td>
          <p>Defines that the cmdlet will show no prompt before executing the command.</p>
        </td>
        <td style="width:10%;">
          <p><code>SwitchParameter</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>
    </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.

## Examples

::: example
### Stopping Restore Job

This example shows how to stop the restore job.

```
$restore = Get-VESQLRDSDatabaseRestore
Stop-VESQLRDSDatabaseRestore -DatabaseRestore $restore[3] -Force
```

Perform the following steps:

1. Run the [`Get-VESQLRDSDatabaseRestore`](get-vesqlrdsdatabaserestore.md) cmdlet. Save the result to the `$restore` variable.

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

2. Run the `Stop-VESQLRDSDatabaseRestore` cmdlet. Set the `$restore` variable as the `DatabaseRestore` parameter value and select the necessary restore job. Note that the `Force` parameter is also provided, which will cause the restore job to be stopped without any additional prompts or warnings.

:::

## Related Commands

[`Get-VESQLRDSDatabaseRestore`](get-vesqlrdsdatabaserestore.md)