---
title: "Get-VESQLDatabasePublish"
description: "Returns active publishing jobs for backed-up Microsoft SQL Server databases. Product: Veeam Backup & Replication Product Edition: Community, Standard, Enterprise, Enterprise Plus, Veeam Universal License This cmdlet provides the following paramet"
canonical: "https://helpcenter.veeam.com/docs/vbr/explorers_powershell/get-vesqldatabasepublish.html"
breadcrumb: "Veeam Explorers PowerShell Reference > Veeam Explorers PowerShell Reference > Veeam Explorer for Microsoft SQL Server > Get-VESQLDatabasePublish"
dateModified: "2026-08-18"
---

# Get-VESQLDatabasePublish

## Short Description
Returns active publishing jobs for backed-up Microsoft SQL Server databases.

**Product**: Veeam Backup & Replication

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

## Syntax

This cmdlet provides the following parameter sets:

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

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

```
Get-VESQLDatabasePublish [-DatabaseName <String[]>] [-ServerName <String[]>] [-InstanceName <String[]>] [<CommonParameters>]
```
  </li>
</ul>

## Detailed Description
This cmdlet returns information about the publishing process for backed-up Microsoft SQL Server databases.

## 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 an array of names of Microsoft SQL Server databases. The cmdlet will return an array of databases with the specified names that have ongoing publishing jobs.</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">InstanceName</span></p>
        </td>
        <td>
          <p>Specifies an array of names of Microsoft SQL Server instances. The cmdlet will return an array of databases on the specified instances that have ongoing publishing jobs.</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 publishing job. The cmdlet will return information about the publishing process performed for the specified database.</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>
      <tr style="vertical-align:top">
        <td>
          <p class="Table_Text_Bold"><span class="Table_Text_Bold">ServerName</span></p>
        </td>
        <td>
          <p>Specifies an array of names of target Microsoft SQL Server machines (as DNS names or IP addresses). The cmdlet will return an array of databases that have ongoing publishing jobs to the specified target servers.</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>
    </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 [`VESQLDatabasePublish`](vesqldatabasepublish.md)`[]` array that contains information about the publishing process of Microsoft SQL Server databases.

## Examples

::: example
### Example 1. Getting All Publishing Jobs

This command returns all active Microsoft SQL Server publishing jobs. Save the result to the `$publish` variable to be able to use it with other cmdlets.

```
$publish = Get-VESQLDatabasePublish
```

:::

::: example
### Example 2. Getting Publishing Job by Job ID

This example shows how to get a specific publishing job by its job ID.

```
Get-VESQLDatabasePublish
$publish = Get-VESQLDatabasePublish -JobId "9c1b10de-7236-4905-a817-70db4e003f39"
```

Perform the following steps:

1. Run the `Get-VESQLDatabasePublish` cmdlet. This command returns all active Microsoft SQL Server publishing jobs. Save the `JobId` value for the publishing job that you need.
2. Run the `Get-VESQLDatabasePublish` cmdlet. Specify the `JobId` parameter value. Save the result to the `$publish` variable to be able to use it with other cmdlets.

:::

::: example
### Example 3. Getting All Publishing Jobs for Databases with Specific Names on Specific Instances

This example shows how to get an array of active publishing jobs for databases with specific names located on specific instances.

```
$dbnames = @("fiscal", "sales", "IT")
$instancenames = @("instance1", "instance2")
$publish = Get-VESQLDatabasePublish -DatabaseName $dbnames -InstanceName $instancenames
```

Perform the following steps:

1. Declare the `$dbnames` variable. Assign to this variable an array with the names of the necessary Microsoft SQL Server databases.
2. Declare the `$instancenames` variable. Assign to this variable an array with the names of the Microsoft SQL Server instances that you want to query.
3. Run the `Get-VESQLDatabasePublish` cmdlet. Set the `$dbnames` variable as the `DatabaseName` parameter value. Set the `$instancenames` variable as the `InstanceName` parameter value. Save the result to the `$publish` variable to be able to use it with other cmdlets.

:::

::: example
### Example 4. Getting All Publishing Jobs to Specific Target Servers

This example shows how to get an array of active publishing jobs to specific target servers.

```
$targetservernames = @("srv89", "srv90")
$publish = Get-VESQLDatabasePublish -ServerName $targetservernames
```

Perform the following steps:

1. Declare the `$targetservernames` variable. Assign to this variable an array with the names of the necessary target servers.
2. Run the `Get-VESQLDatabasePublish` cmdlet. Set the `$targetservernames` variable as the `ServerName` parameter value. Save the result to the `$publish` variable to be able to use it with other cmdlets.

:::