---
title: "Stop-VESQLDatabasePublish"
description: "Unpublishes a Microsoft SQL Server database from the target server. Product: Veeam Backup & Replication Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdlet unpublishes a Microsoft SQL Server data"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/stop-vesqldatabasepublish.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > Stop-VESQLDatabasePublish"
dateModified: "2026-08-18"
---

# Stop-VESQLDatabasePublish

## Short Description
Unpublishes a Microsoft SQL Server database from the target server.

**Product**: Veeam Backup & Replication

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

## Syntax
```
Stop-VESQLDatabasePublish [-DatabasePublish] <VESQLDatabasePublish> [-Force] [<CommonParameters>]
```

## Detailed Description
This cmdlet unpublishes a Microsoft SQL Server database from the target server.

::: note

Publishing jobs will not stop automatically if you close the PowerShell console. To stop a publishing job, you must run the `Stop-VESQLDatabasePublish` cmdlet.

:::

## 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">DatabasePublish</span></p>
        </td>
        <td>
          <p>Specifies the publishing process for a Microsoft SQL Server database. The cmdlet will stop the process and unpublish the database from the target Microsoft SQL Server machine.</p><p>Accepts the <a href="vesqldatabasepublish.md"><code>VESQLDatabasePublish</code></a> object. To get this object, run the <a href="get-vesqldatabasepublish.md"><code>Get-VESQLDatabasePublish</code></a> cmdlet.</p>
        </td>
        <td style="width:10%;">
          <p><a href="vesqldatabasepublish.md"><code>VESQLDatabasePublish</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 Publishing Process for a Microsoft SQL Server Database

This example shows how to unpublish a Microsoft SQL Server database.

```
$publish = Get-VESQLDatabasePublish -DatabaseName "db1"
Stop-VESQLDatabasePublish -DatabasePublish $publish
```

Perform the following steps:

1. Run the [`Get-VESQLDatabasePublish`](get-vesqldatabasepublish.md) cmdlet. Specify the `DatabaseName` parameter value and save the result to the `$publish` variable.
2. Run the `Stop-VESQLDatabasePublish` cmdlet. Set the `$publish` variable as the `DatabasePublish` parameter value.

:::

## Related Commands

[`Get-VESQLDatabasePublish`](get-vesqldatabasepublish.md)