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

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
DatabasePublish	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. Accepts the `VESQLDatabasePublish` object. To get this object, run the `Get-VESQLDatabasePublish` cmdlet.	`VESQLDatabasePublish`	True	0	True (ByValue)
Force	Defines that the cmdlet will show no prompt before executing the command.	`SwitchParameter`	False	Named	False

<CommonParameters>

This cmdlet supports Microsoft PowerShell common parameters. For more information on common parameters, see the About Common Parameters section of Microsoft Docs.

Examples

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:

Run the Get-VESQLDatabasePublish cmdlet. Specify the DatabaseName parameter value and save the result to the $publish variable.
Run the Stop-VESQLDatabasePublish cmdlet. Set the $publish variable as the DatabasePublish parameter value.

Get-VESQLDatabasePublish