---
title: "Stop-VEPSQLDatabaseRestore"
description: "Stops a restore job for a backed-up PostgreSQL database. Product: Veeam Backup & Replication Product Edition: Enterprise Plus, Veeam Universal License This cmdlet stops a restore job for a backed-up PostgreSQL database."
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/stop-vepsqldatabaserestore.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for PostgreSQL > Stop-VEPSQLDatabaseRestore"
dateModified: "2026-08-18"
---

# Stop-VEPSQLDatabaseRestore

## Short Description
Stops a restore job for a backed-up PostgreSQL database.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Stop-VEPSQLDatabaseRestore [-Restore] <VEPSQLDatabaseRestore> [-Force] [<CommonParameters>]
```

## Detailed Description
This cmdlet stops a restore job for a backed-up PostgreSQL database.

## 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">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>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">Restore</span></p>
        </td>
        <td>
          <p>Specifies a restore job for a PostgreSQL database.</p><p>Accepts the <a href="vepsqldatabaserestore.md"><code>VEPSQLDatabaseRestore</code></a> object. To get this object, run the <a href="get-vepsqldatabaserestore.md"><code>Get-VEPSQLDatabaseRestore</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vepsqldatabaserestore.md"><code>VEPSQLDatabaseRestore</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>
    </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-VEPSQLDatabaseRestore
Stop-VEPSQLDatabaseRestore -Restore $restore[3] -Force
```

Perform the following steps:

1. Run the [`Get-VEPSQLDatabaseRestore`](get-vepsqldatabaserestore.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-VEPSQLDatabaseRestore` cmdlet. Set the `$restore` variable as the `Restore` 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-VEPSQLDatabaseRestore`](get-vepsqldatabaserestore.md)