Stop-VESQLDatabaseRestore

Short Description

Stops a restore job for a Microsoft SQL Server database.

Product: Veeam Backup & Replication

Product Edition: Enterprise Plus, Veeam Universal License

Syntax

Stop-VESQLDatabaseRestore [-DatabaseRestore] <VESQLDatabaseRestore> [-Force] [<CommonParameters>]

Detailed Description

This cmdlet stops a restore job for a Microsoft SQL Server database.

Parameters

Parameters
Parameter	Description	Type	Required	Position	Accept Pipeline Input
DatabaseRestore	Specifies a restore job for a Microsoft SQL Server database. Accepts the `VESQLDatabaseRestore` object. To get this object, run the `Get-VESQLDatabaseRestore` cmdlet.	`VESQLDatabaseRestore`	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 Restore Job

This example shows how to stop a restore job.

$restore = Get-VESQLDatabaseRestore

Stop-VESQLDatabaseRestore -DatabaseRestore $restore[3] -Force

Perform the following steps:

Run the Get-VESQLDatabaseRestore 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).
Run the Stop-VESQLDatabaseRestore 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.

Get-VESQLDatabaseRestore